trees
3,267 rows where qSpecies_id = 67 sorted by PlotSize descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67499 | 175713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 637 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6009802.33788 | 2091425.99493 | 37.7232107699499 | -122.408225566251 | (37.7232107699499, -122.408225566251) | 10 | 3 | 7 | 309 | 28 | |||
6350 | 117651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5101 Anza St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5982808.62425 | 2111663.85148 | 37.77722982032 | -122.503033613638 | (37.77722982032, -122.503033613638) | 11 | 6 | 2 | 55 | 26 | |||
6802 | 188921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012543.15348 | 2101838.55647 | 37.751954571155 | -122.399481710736 | (37.751954571155, -122.399481710736) | 10 | 3 | 8 | 28856 | 29 | |||
12851 | 188928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158 | (37.7519707940373, -122.39914787158) | 10 | 3 | 8 | 28856 | 29 | |||
21698 | 222228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5735 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000718.4413 | 2097027.59574 | 37.7380786327218 | -122.440028227017 | (37.7380786327218, -122.440028227017) | 2 | 7 | 5 | 63 | 7 | |||
22168 | 188924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012576.69697 | 2101839.95145 | 37.7519602710713 | -122.399365809709 | (37.7519602710713, -122.399365809709) | 10 | 3 | 8 | 28856 | 29 | |||
35134 | 188923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012568.02494 | 2101839.32896 | 37.7519580785092 | -122.399395755332 | (37.7519580785092, -122.399395755332) | 10 | 3 | 8 | 28856 | 29 | |||
36517 | 188943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6011566.68451 | 2097067.81933 | 37.7388006794984 | -122.402523060487 | (37.7388006794984, -122.402523060487) | 10 | 3 | 8 | 58 | 1 | |||
37008 | 188941 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011606.7054 | 2097039.0351 | 37.738723878306 | -122.402382662836 | (37.738723878306, -122.402382662836) | 10 | 3 | 8 | 58 | 1 | |||
37241 | 204602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5998668.22296 | 2093529.87364 | 37.7283577869805 | -122.446865208659 | (37.7283577869805, -122.446865208659) | 9 | 7 | 4 | 28861 | 40 | |||
44988 | 188915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012439.14392 | 2101833.80139 | 37.7519357168614 | -122.39984105913 | (37.7519357168614, -122.39984105913) | 10 | 3 | 8 | 28856 | 29 | |||
46684 | 125865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 47 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6011401.82838 | 2120281.49833 | 37.8025309385205 | -122.404726857271 | (37.8025309385205, -122.404726857271) | 3 | 1 | 10 | 308 | 23 | |||
50963 | 188920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012536.08431 | 2101837.90146 | 37.7519523786127 | -122.399506111115 | (37.7519523786127, -122.399506111115) | 10 | 3 | 8 | 28856 | 29 | |||
81657 | 188919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012522.72897 | 2101837.16706 | 37.7519496176856 | -122.399552244535 | (37.7519496176856, -122.399552244535) | 10 | 3 | 8 | 28856 | 29 | |||
92450 | 188925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012587.76707 | 2101840.20592 | 37.7519615867766 | -122.399327545327 | (37.7519615867766, -122.399327545327) | 10 | 3 | 8 | 28856 | 29 | |||
94066 | 188942 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011601.74393 | 2097042.7843 | 37.7387338958451 | -122.402400080905 | (37.7387338958451, -122.402400080905) | 10 | 3 | 8 | 58 | 1 | |||
94613 | 247002 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Valley St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6003223.72191 | 2099183.90934 | 37.7441416748926 | -122.431520126078 | (37.7441416748926, -122.431520126078) | 2 | 7 | 5 | 63 | 22 | |||
96698 | 188927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012620.56924 | 2101841.45288 | 37.7519668387962 | -122.399214197496 | (37.7519668387962, -122.399214197496) | 10 | 3 | 8 | 28856 | 29 | |||
98639 | 222498 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 749 Dolores St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005048.62848 | 2104037.34369 | 37.7575713454444 | -122.425555344718 | (37.7575713454444, -122.425555344718) | 2 | 4 | 5 | 28859 | 19 | |||
99173 | 125780 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Emerson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5998681.19546 | 2113401.84982 | 37.7829220585575 | -122.448250722201 | (37.7829220585575, -122.448250722201) | 15 | 6 | 1 | 54 | 31 | |||
102190 | 125867 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 49 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6011400.22925 | 2120293.8654 | 37.8025648060933 | -122.404733262242 | (37.8025648060933, -122.404733262242) | 3 | 1 | 10 | 308 | 23 | |||
102481 | 125868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 50 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6011397.07627 | 2120306.83138 | 37.8026002312778 | -122.404745086537 | (37.8026002312778, -122.404745086537) | 3 | 1 | 10 | 308 | 23 | |||
102674 | 125864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 46 | Median : Yard | Tree | DPW 1 | 11 | Width 8ft | 6011404.31889 | 2120270.95614 | 37.8025021314422 | -122.404717496217 | (37.8025021314422, -122.404717496217) | 3 | 1 | 10 | 308 | 23 | |||
106602 | 188918 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012503.47423 | 2101836.59993 | 37.7519469871825 | -122.399618790794 | (37.7519469871825, -122.399618790794) | 10 | 3 | 8 | 28856 | 29 | |||
110646 | 222241 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 233 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 8ft | 5998966.85678 | 2106784.6526 | 37.7647692538279 | -122.446786167251 | (37.7647692538279, -122.446786167251) | 15 | 5 | 11 | 29492 | 9 | |||
112318 | 125866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 48 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6011400.87154 | 2120290.44992 | 37.802555463919 | -122.404730798994 | (37.802555463919, -122.404730798994) | 3 | 1 | 10 | 308 | 23 | |||
112461 | 188916 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012464.32295 | 2101833.92886 | 37.7519374705385 | -122.39975399485 | (37.7519374705385, -122.39975399485) | 10 | 3 | 8 | 28856 | 29 | |||
132834 | 220805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | 2 | 7 | 5 | 63 | 7 | |||
134807 | 188917 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012491.91377 | 2101835.87627 | 37.7519443557542 | -122.399658717969 | (37.7519443557542, -122.399658717969) | 10 | 3 | 8 | 28856 | 29 | |||
137948 | 222186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2103 Castro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6002703.56288 | 2099413.26301 | 37.7447419309924 | -122.433335105435 | (37.7447419309924, -122.433335105435) | 2 | 7 | 5 | 63 | 22 | |||
141582 | 117652 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5101 Anza St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5982828.88915 | 2111662.81749 | 37.7772281723606 | -122.502963435462 | (37.7772281723606, -122.502963435462) | 11 | 6 | 2 | 55 | 26 | |||
145467 | 204366 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 5993020.52615 | 2090799.19022 | 37.7205357338073 | -122.466191031497 | (37.7205357338073, -122.466191031497) | 9 | 8 | 6 | 64 | 24 | |||
145626 | 188882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 869 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011336.63713 | 2104304.99863 | 37.7586595539197 | -122.403827579285 | (37.7586595539197, -122.403827579285) | 10 | 3 | 8 | 28856 | 29 | |||
150093 | 246728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Ripley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6008612.87637 | 2099109.67638 | 37.7442418234114 | -122.412880303405 | (37.7442418234114, -122.412880303405) | 2 | 7 | 7 | 28859 | 2 | |||
154009 | 188914 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012427.94611 | 2101835.1466 | 37.7519387862441 | -122.399879877452 | (37.7519387862441, -122.399879877452) | 10 | 3 | 8 | 28856 | 29 | |||
157602 | 125781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Emerson St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5998685.74713 | 2113372.01859 | 37.7828404099945 | -122.448232826606 | (37.7828404099945, -122.448232826606) | 15 | 6 | 1 | 54 | 31 | |||
161143 | 188913 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6012415.40438 | 2101833.48488 | 37.7519335243109 | -122.399923132139 | (37.7519335243109, -122.399923132139) | 10 | 3 | 8 | 28856 | 29 | |||
162623 | 188926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012598.03871 | 2101840.63611 | 37.7519633404581 | -122.399292054486 | (37.7519633404581, -122.399292054486) | 10 | 3 | 8 | 28856 | 29 | |||
163954 | 175585 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1711 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5998173.65271 | 2088704.87448 | 37.7150811936116 | -122.448227659988 | (37.7150811936116, -122.448227659988) | 9 | 7 | 6 | 28861 | 25 | |||
164637 | 188922 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012559.84354 | 2101839.17569 | 37.7519572016621 | -122.399424037211 | (37.7519572016621, -122.399424037211) | 10 | 3 | 8 | 28856 | 29 | |||
172633 | 204582 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5999570.33408 | 2095534.33569 | 37.7339130665349 | -122.443890535522 | (37.7339130665349, -122.443890535522) | 9 | 7 | 4 | 63 | 40 | |||
189630 | 204367 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Ramsell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5993020.48058 | 2090812.3003 | 37.7205717282756 | -122.466192141252 | (37.7205717282756, -122.466192141252) | 9 | 8 | 6 | 64 | 24 | |||
45861 | 202030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6013974.71046 | 2090993.7917 | 37.7222567763217 | -122.393772134473 | (37.7222567763217, -122.393772134473) | 10 | 3 | 8 | 58 | 1 | |||
116881 | 247672 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 170 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6001935.423 | 2108631.33327 | 37.7700089198994 | -122.436650881551 | (37.7700089198994, -122.436650881551) | 15 | 5 | 5 | 29492 | 9 | |||
10804 | 125788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5999154.81918 | 2118474.67758 | 37.7968777722368 | -122.446977352345 | (37.7968777722368, -122.446977352345) | 13 | 9 | 1 | 57 | 17 | |||
14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
23518 | 175745 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 52 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6003007.00361 | 2086627.02122 | 37.7096509944604 | -122.431373299139 | (37.7096509944604, -122.431373299139) | 9 | 7 | 6 | 28861 | 5 | |||
25461 | 188931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012684.2362 | 2101844.79492 | 37.751979563304 | -122.398994261091 | (37.751979563304, -122.398994261091) | 10 | 3 | 8 | 28856 | 29 | |||
28203 | 118808 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 894 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5981738.11732 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | 11 | 6 | 2 | 55 | 26 | |||
29895 | 220786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 27th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005806.54234 | 2100249.31165 | 37.747213079126 | -122.422664984796 | (37.747213079126, -122.422664984796) | 2 | 7 | 5 | 28859 | 22 | |||
40740 | 175739 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 Chicago Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6002794.41849 | 2086722.13696 | 37.7099001111816 | -122.432114818072 | (37.7099001111816, -122.432114818072) | 9 | 7 | 6 | 28861 | 5 | |||
47180 | 175749 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 348 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6002804.80085 | 2086492.54523 | 37.7092702907661 | -122.432062550353 | (37.7092702907661, -122.432062550353) | 9 | 7 | 6 | 28861 | 5 | |||
47212 | 175596 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Lisbon St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001043.54225 | 2088836.75005 | 37.715606945381 | -122.438317555522 | (37.715606945381, -122.438317555522) | 9 | 7 | 6 | 28861 | 5 | |||
50719 | 204389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5991049.04584 | 2094416.57218 | 37.7303542198692 | -122.473269434337 | (37.7303542198692, -122.473269434337) | 9 | 8 | 4 | 64 | 40 | |||
60678 | 175733 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1183 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001131.65449 | 2087116.65406 | 37.710888955334 | -122.437889869445 | (37.710888955334, -122.437889869445) | 9 | 7 | 6 | 28861 | 5 | |||
61856 | 175744 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Baltimore Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003028.75595 | 2086646.47615 | 37.7097056462618 | -122.431299507078 | (37.7097056462618, -122.431299507078) | 9 | 7 | 6 | 28861 | 5 | |||
68658 | 222175 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4220 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002470.36275 | 2100366.71232 | 37.7473466464472 | -122.434209614287 | (37.7473466464472, -122.434209614287) | 2 | 4 | 5 | 63 | 22 | |||
71124 | 205850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.462541222916 | (37.7164641180118, -122.462541222916) | 9 | 8 | 6 | 28861 | 24 | |||
75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
97460 | 205849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994041.34174 | 2089295.54399 | 37.7164659256374 | -122.46255340963 | (37.7164659256374, -122.46255340963) | 9 | 8 | 6 | 28861 | 24 | |||
99669 | 175740 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6002767.48185 | 2086755.45159 | 37.7099900586728 | -122.432210293693 | (37.7099900586728, -122.432210293693) | 9 | 7 | 6 | 28861 | 5 | |||
101658 | 204606 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Circular Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5999593.89835 | 2093609.08304 | 37.7286281168878 | -122.443670805062 | (37.7286281168878, -122.443670805062) | 9 | 7 | 4 | 63 | 40 | |||
103472 | 188930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6012673.63731 | 2101844.052 | 37.7519769327872 | -122.399030861684 | (37.7519769327872, -122.399030861684) | 10 | 3 | 8 | 28856 | 29 | |||
104696 | 118809 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 894 46th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5981738.19338 | 2109667.15136 | 37.7716844925674 | -122.50658839183 | (37.7716844925674, -122.50658839183) | 11 | 6 | 2 | 55 | 26 | |||
111450 | 175741 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 Chicago Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6002753.09913 | 2086743.14922 | 37.709955463542 | -122.432259125067 | (37.709955463542, -122.432259125067) | 9 | 7 | 6 | 28861 | 5 | |||
114055 | 175659 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Gorham St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6002127.87669 | 2094427.73374 | 37.7310201453528 | -122.434969230247 | (37.7310201453528, -122.434969230247) | 9 | 7 | 5 | 28861 | 25 | |||
114178 | 175742 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 Chicago Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6002727.11736 | 2086720.58714 | 37.7098920397623 | -122.432347312594 | (37.7098920397623, -122.432347312594) | 9 | 7 | 6 | 28861 | 5 | |||
120672 | 204377 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 718 Head St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993540.82966 | 2090600.12558 | 37.7200191560468 | -122.464378076488 | (37.7200191560468, -122.464378076488) | 9 | 8 | 6 | 64 | 24 | |||
121258 | 204607 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Circular Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5999588.13262 | 2093605.97991 | 37.7286192675636 | -122.443690514623 | (37.7286192675636, -122.443690514623) | 9 | 7 | 4 | 63 | 40 | |||
126793 | 175750 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 348 Naylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002816.75765 | 2086477.59625 | 37.7092299219895 | -122.432020159019 | (37.7092299219895, -122.432020159019) | 9 | 7 | 6 | 28861 | 5 | |||
137469 | 204592 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80 Congo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000106.35116 | 2094008.99086 | 37.7297553855902 | -122.441927922547 | (37.7297553855902, -122.441927922547) | 9 | 7 | 4 | 63 | 40 | |||
137754 | 205760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Malta Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5999813.17886 | 2095831.7198 | 37.7347434627438 | -122.443072299967 | (37.7347434627438, -122.443072299967) | 9 | 7 | 4 | 63 | 40 | |||
140479 | 175602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002031.92275 | 2090419.60953 | 37.7200092931862 | -122.435014408592 | (37.7200092931862, -122.435014408592) | 9 | 7 | 6 | 28861 | 5 | |||
141561 | 204398 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1346 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 5994282.41464 | 2106337.33342 | 37.7632723142903 | -122.462955855339 | (37.7632723142903, -122.462955855339) | 1 | 5 | 11 | 56 | 12 | |||
141737 | 205871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 111 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991654.88774 | 2089307.44903 | 37.7163608911211 | -122.470802959995 | (37.7163608911211, -122.470802959995) | 9 | 8 | 6 | 64 | 24 | |||
150867 | 175746 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 52 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002987.27121 | 2086606.39333 | 37.7095932364015 | -122.431440026154 | (37.7095932364015, -122.431440026154) | 9 | 7 | 6 | 28861 | 5 | |||
160012 | 175660 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Gorham St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002127.94999 | 2094431.27872 | 37.7310298832205 | -122.434969230269 | (37.7310298832205, -122.434969230269) | 9 | 7 | 5 | 28861 | 25 | |||
160261 | 205761 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Malta Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999812.15419 | 2095813.64108 | 37.7346937644012 | -122.443074544653 | (37.7346937644012, -122.443074544653) | 9 | 7 | 4 | 63 | 40 | |||
164765 | 188929 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012662.88152 | 2101843.47178 | 37.7519747402545 | -122.39906801628 | (37.7519747402545, -122.39906801628) | 10 | 3 | 8 | 28856 | 29 | |||
165584 | 175648 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | 1 | 8 | 4 | 64 | 14 | |||
166369 | 220806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 6003687.50559 | 2095763.31168 | 37.7347757726743 | -122.429672549851 | (37.7347757726743, -122.429672549851) | 2 | 7 | 5 | 63 | 7 | |||
172655 | 175651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008 | (37.7189698369625, -122.47492674008) | 1 | 8 | 4 | 64 | 14 | |||
178692 | 204605 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Circular Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5999601.48923 | 2093614.0273 | 37.72864212562 | -122.443644918075 | (37.72864212562, -122.443644918075) | 9 | 7 | 4 | 63 | 40 | |||
178752 | 175591 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Moneta Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5997970.37238 | 2088102.39912 | 37.713415311033 | -122.44888690892 | (37.713415311033, -122.44888690892) | 9 | 7 | 6 | 28861 | 25 | |||
180792 | 125789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2812 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 5999154.23094 | 2118479.17049 | 37.7968900749607 | -122.446979711267 | (37.7968900749607, -122.446979711267) | 13 | 9 | 1 | 57 | 17 | |||
188208 | 175743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 262 Chicago Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6002717.2522 | 2086712.60101 | 37.7098695521959 | -122.432380838397 | (37.7098695521959, -122.432380838397) | 9 | 7 | 6 | 28861 | 5 | |||
191993 | 188889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 812 Rhode Island St | 2 | : | Tree | Private 2 | 3 | Width 6ft | 6011824.00346 | 2104560.8876 | 37.7593893834298 | -122.402160024888 | (37.7593893834298, -122.402160024888) | 10 | 3 | 8 | 28856 | 29 | |||
11996 | 204552 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 60 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | 9 | 7 | 4 | 59 | 40 | |||
20134 | 121874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 198 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 5990255.88241 | 2114155.38481 | 37.7845057863421 | -122.477453587346 | (37.7845057863421, -122.477453587346) | 11 | 6 | 2 | 55 | 26 | |||
23213 | 188987 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012918.63111 | 2094968.59879 | 37.7331120403799 | -122.397701430785 | (37.7331120403799, -122.397701430785) | 10 | 3 | 8 | 58 | 1 | |||
23467 | 117983 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 5984187.50987 | 2112858.34 | 37.7805904888414 | -122.498351927647 | (37.7805904888414, -122.498351927647) | 11 | 6 | 2 | 55 | 26 | |||
23868 | 205774 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 367 Kensington Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5994104.03782 | 2099097.57437 | 37.7433835122355 | -122.463047484554 | (37.7433835122355, -122.463047484554) | 1 | 8 | 4 | 59 | 40 | |||
28211 | 175688 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1849 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6005530.78221 | 2092211.86243 | 37.7251284788867 | -122.423047355852 | (37.7251284788867, -122.423047355852) | 9 | 7 | 7 | 309 | 5 | |||
28402 | 222382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 532 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6002964.94122 | 2105091.2167 | 37.7603470723843 | -122.432836858561 | (37.7603470723843, -122.432836858561) | 2 | 4 | 5 | 28862 | 3 | |||
36928 | 205763 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 12 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 5999213.2528 | 2097587.01076 | 37.739528850671 | -122.445272603768 | (37.739528850671, -122.445272603768) | 9 | 7 | 4 | 59 | 40 | |||
38394 | 202114 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6011999.88588 | 2092811.04962 | 37.7271366533292 | -122.400726278018 | (37.7271366533292, -122.400726278018) | 10 | 3 | 8 | 58 | 1 | |||
41910 | 205764 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 13 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5999220.24224 | 2097585.41843 | 37.7395248774812 | -122.445248322956 | (37.7395248774812, -122.445248322956) | 9 | 7 | 4 | 59 | 40 | |||
43539 | 175599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 192 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6004164.31837 | 2089345.24941 | 37.7171801843089 | -122.427566943762 | (37.7171801843089, -122.427566943762) | 9 | 7 | 6 | 28861 | 5 | |||
45072 | 205769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 20 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 5999260.68226 | 2097573.72632 | 37.7394950820195 | -122.445107659105 | (37.7394950820195, -122.445107659105) | 9 | 7 | 4 | 59 | 40 | |||
45860 | 222418 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Henry St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6003331.75613 | 2107393.85381 | 37.7666903559042 | -122.431732624157 | (37.7666903559042, -122.431732624157) | 15 | 5 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );