Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51671 | 51671 | 112792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5 | 6010303.89255 | 2116225.84414 | 37.7913336739481 | -122.40824006785101 | (37.7913336739481, -122.408240067851) | ||||
| 52401 | 52401 | 112793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 8 | 6010304.6147 | 2116218.08658 | 37.7913124139936 | -122.40823702184099 | (37.7913124139936, -122.408237021841) | ||||
| 56387 | 56387 | 112791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 7 | 6010302.18584 | 2116235.66689 | 37.791360549286104 | -122.408246666156 | (37.7913605492861, -122.408246666156) | ||||
| 134118 | 134118 | 112789 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 23x Joice St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 8 | 3x3 | 6010300.14411 | 2116243.45137 | 37.7913818092657 | -122.408254279811 | (37.7913818092657, -122.408254279811) | |||
| 142909 | 142909 | 112794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21x JOICE ST | 5 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 6010276.0 | 2116206.0 | 37.7912776248382 | -122.40833517558599 | (37.7912776248382, -122.408335175586) | |||||
| 48984 | 48984 | 200734 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1434 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 6015941.8417 | 2094834.993 | 37.7329130736504 | -122.387239974213 | (37.7329130736504, -122.387239974213) | |||
| 37058 | 37058 | 204587 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998761.6398599995 | 2095307.9959099998 | 37.733245428730996 | -122.446670146634 | (37.733245428731, -122.446670146634) | ||||
| 39127 | 39127 | 247002 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Valley St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003223.72191 | 2099183.9093400002 | 37.7441416748926 | -122.431520126078 | (37.7441416748926, -122.431520126078) | |||
| 41959 | 41959 | 250203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 203 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6011748.4940599995 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | |||
| 57450 | 57450 | 247885 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009895.877069999 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | ||||
| 64944 | 64944 | 218223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 399 Claremont Blvd | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5993474.17256 | 2097846.02445 | 37.73991076848 | -122.465134496264 | (37.73991076848, -122.465134496264) | ||||
| 65858 | 65858 | 204573 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 403 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 10ft | 6000740.47882 | 2095257.8114200002 | 37.7332204725414 | -122.439825179911 | (37.7332204725414, -122.439825179911) | |||
| 67351 | 67351 | 247884 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009916.04567 | 2098399.5551400003 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | ||||
| 67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
| 69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
| 70865 | 70865 | 204586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Edna St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998760.41171 | 2095319.0068400002 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | ||||
| 165572 | 165572 | 250224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | |||
| 166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
| 166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
| 172111 | 172111 | 250226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.042090001 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | |||
| 182436 | 182436 | 204570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 404 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000772.023709999 | 2095261.55097 | 37.733232536033 | -122.43971638892 | (37.733232536033, -122.43971638892) | ||||
| 184037 | 184037 | 247875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 388 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009902.15427 | 2098392.46906 | 37.742344813273604 | -122.408371660244 | (37.7423448132736, -122.408371660244) | ||||
| 78555 | 78555 | 116671 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 154924 | 154924 | 204382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228741999 | (37.7134396116198, -122.46893228742) | ||||
| 179961 | 179961 | 204383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992172.93339 | 2088222.9751099998 | 37.7134131337717 | -122.46893348261699 | (37.7134131337717, -122.468933482617) | ||||
| 184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
| 10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
| 11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
| 11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
| 13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
| 18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
| 19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
| 19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
| 20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
| 22386 | 22386 | 9093 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.78025641160821 | -122.48095732694999 | (37.7802564116082, -122.48095732695) | |||
| 22392 | 22392 | 9015 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990451.7846 | 2112676.0938 | 37.780455430166704 | -122.47666772777599 | (37.7804554301667, -122.476667727776) | |||
| 22394 | 22394 | 9094 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.48098115319901 | (37.7802427184836, -122.480981153199) | |||
| 22395 | 22395 | 9019 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | ||
| 22405 | 22405 | 9178 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | |||
| 22427 | 22427 | 9095 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.3055 | 2112634.6929 | 37.780269260588604 | -122.480983721798 | (37.7802692605886, -122.480983721798) | |||
| 22433 | 22433 | 9091 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989224.2748 | 2112631.4669 | 37.7802616218044 | -122.48091094389 | (37.7802616218044, -122.48091094389) | |||
| 22441 | 22441 | 9219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.779994079355895 | -122.487366491184 | (37.7799940793559, -122.487366491184) | |||
| 22462 | 22462 | 9179 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.3441 | 2112595.2541 | 37.7800890496186 | -122.48525653433799 | (37.7800890496186, -122.485256534338) | |||
| 22464 | 22464 | 9180 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.6795 | 2112585.8637 | 37.7800632857697 | -122.485254684827 | (37.7800632857697, -122.485254684827) | |||
| 22465 | 22465 | 9099 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.780247936097396 | -122.481022231507 | (37.7802479360974, -122.481022231507) | |||
| 22471 | 22471 | 9181 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | |||
| 22497 | 22497 | 9218 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.78000136471471 | -122.48726222211799 | (37.7800013647147, -122.487262222118) | |||
| 22507 | 22507 | 9049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | |||
| 22524 | 22524 | 9096 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) | |||
| 22529 | 22529 | 9177 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987977.7406 | 2112589.2174 | 37.7800730801841 | -122.485220125518 | (37.7800730801841, -122.485220125518) | |||
| 22540 | 22540 | 9014 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990456.086 | 2112679.8576 | 37.7804660140104 | -122.476653122424 | (37.7804660140104, -122.476653122424) | |||
| 22541 | 22541 | 9137 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.48312118538799 | (37.7801678269123, -122.483121185388) | |||
| 22544 | 22544 | 9217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.77996641187121 | -122.487258965224 | (37.7799664118712, -122.487258965224) | |||
| 22548 | 22548 | 9215 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.779982318766706 | -122.48718974831999 | (37.7799823187667, -122.48718974832) | |||
| 22573 | 22573 | 9017 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990440.4935 | 2112674.4808 | 37.780450346394794 | -122.476706670705 | (37.7804503463948, -122.476706670705) | |||
| 22584 | 22584 | 9016 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990445.3325 | 2112679.3199 | 37.7804639139017 | -122.476690284152 | (37.7804639139017, -122.476690284152) | |||
| 22612 | 22612 | 9018 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990428.6646 | 2112675.0185 | 37.7804511366409 | -122.476747631291 | (37.7804511366409, -122.476747631291) | |||
| 22637 | 22637 | 9140 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988567.4931 | 2112610.849 | 37.7801668120621 | -122.48318151551001 | (37.7801668120621, -122.48318151551) | |||
| 22655 | 22655 | 9184 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987942.8619 | 2112587.5406 | 37.7800664442915 | -122.485340662126 | (37.7800664442915, -122.485340662126) | |||
| 22662 | 22662 | 8993 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990760.6778 | 2112689.8051 | 37.7805109894096 | -122.47560013351601 | (37.7805109894096, -122.475600133516) | |||
| 22666 | 22666 | 9139 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988574.5359 | 2112606.1537 | 37.7801543299329 | -122.483156807286 | (37.7801543299329, -122.483156807286) | |||
| 22696 | 22696 | 9182 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987952.9231 | 2112592.5712 | 37.780080843030795 | -122.485306225563 | (37.7800808430308, -122.485306225563) | |||
| 22701 | 22701 | 9176 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987984.4481 | 2112593.2419 | 37.7800845210592 | -122.48519721690901 | (37.7800845210592, -122.485197216909) | |||
| 22732 | 22732 | 8994 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5200 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990725.1914 | 2112685.5037 | 37.7804971216948 | -122.47572258227899 | (37.7804971216948, -122.475722582279) | |||
| 22736 | 22736 | 9183 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987946.551 | 2112592.9065 | 37.7800813924537 | -122.485328293876 | (37.7800813924537, -122.485328293876) | |||
| 22762 | 22762 | 9216 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987396.5402 | 2112575.6349 | 37.7800019123037 | -122.487229736584 | (37.7800019123037, -122.487229736584) | |||
| 22773 | 22773 | 9138 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988580.2372 | 2112606.1537 | 37.7801546617076 | -122.48313708412701 | (37.7801546617076, -122.483137084127) | |||
| 22782 | 22782 | 9092 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989215.1343 | 2112630.3915 | 37.7802581377407 | -122.48094248596901 | (37.7802581377407, -122.480942485969) | |||
| 22783 | 22783 | 9048 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989831.8464 | 2112654.8557 | 37.7803611386504 | -122.478810807949 | (37.7803611386504, -122.478810807949) | |||
| 23678 | 23678 | 204530 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999185.819 | 2097019.3718599998 | 37.7379686834 | -122.44532665482299 | (37.7379686834, -122.445326654823) | |||
| 26004 | 26004 | 204552 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | |||
| 27066 | 27066 | 204545 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 73 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499883999 | (37.7386162222515, -122.44348499884) | |||
| 27949 | 27949 | 175625 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.719321051904295 | -122.40959990662701 | (37.7193210519043, -122.409599906627) | |||
| 28651 | 28651 | 175628 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6009091.54392 | 2089913.6992400002 | 37.719018495673396 | -122.41057591204701 | (37.7190184956734, -122.410575912047) | |||
| 29288 | 29288 | 204521 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999107.98616 | 2096985.95215 | 37.737872477539604 | -122.445593357764 | (37.7378724775396, -122.445593357764) | |||
| 30142 | 30142 | 8947 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4800 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | |||
| 30835 | 30835 | 204524 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999142.13445 | 2097001.14376 | 37.7379161396038 | -122.445476382943 | (37.7379161396038, -122.445476382943) | |||
| 35532 | 35532 | 222179 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 6003006.9083 | 2100074.76415 | 37.74657546338779 | -122.432333431553 | (37.7465754633878, -122.432333431553) | |||
| 38482 | 38482 | 204525 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999144.59173 | 2097002.1709099999 | 37.7379191001944 | -122.44546796078998 | (37.7379191001944, -122.44546796079) | |||
| 38657 | 38657 | 204518 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 3ft | 5999003.37096 | 2096940.1521400001 | 37.737740748427704 | -122.445951769058 | (37.7377407484277, -122.445951769058) | |||
| 39319 | 39319 | 205763 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5999213.2528 | 2097587.01076 | 37.739528850671 | -122.445272603768 | (37.739528850671, -122.445272603768) | |||
| 39440 | 39440 | 175627 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 42 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6009089.91396 | 2089921.0786400002 | 37.7190386665864 | -122.410582067034 | (37.7190386665864, -122.410582067034) | |||
| 39765 | 39765 | 175617 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6011092.2529 | 2090548.7162099998 | 37.720874087550705 | -122.40370485781601 | (37.7208740875507, -122.403704857816) | |||
| 39947 | 39947 | 204539 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 3ft | 5999517.17436 | 2097035.6641400002 | 37.7380323275304 | -122.444182170371 | (37.7380323275304, -122.444182170371) | |||
| 40811 | 40811 | 175624 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009382.81472 | 2090013.8898 | 37.719309923703605 | -122.409576165411 | (37.7193099237036, -122.409576165411) | |||
| 40906 | 40906 | 205764 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999220.2422400005 | 2097585.41843 | 37.7395248774812 | -122.445248322956 | (37.7395248774812, -122.445248322956) | |||
| 42569 | 42569 | 175629 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6009095.75789 | 2089908.2938299999 | 37.719003889795104 | -122.410560964431 | (37.7190038897951, -122.410560964431) | |||
| 42713 | 42713 | 204536 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 3ft | 5999467.93009 | 2097036.4178 | 37.738031587391795 | -122.444352485783 | (37.7380315873918, -122.444352485783) | |||
| 42974 | 42974 | 8836 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | |||
| 44817 | 44817 | 204522 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999115.3748 | 2096989.84123 | 37.7378835778536 | -122.445568091304 | (37.7378835778536, -122.445568091304) | |||
| 45103 | 45103 | 204523 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 39 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5999123.85141 | 2096993.9772599998 | 37.7378954183401 | -122.445539080959 | (37.7378954183401, -122.445539080959) | |||
| 45970 | 45970 | 204550 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999656.91248 | 2097430.30525 | 37.739123889545496 | -122.44372737153499 | (37.7391238895455, -122.443727371535) | |||
| 47077 | 47077 | 205769 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5999260.68226 | 2097573.72632 | 37.7394950820195 | -122.44510765910499 | (37.7394950820195, -122.445107659105) | |||
| 48438 | 48438 | 204526 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5999151.1241 | 2097003.92167 | 37.737924280281206 | -122.445445501119 | (37.7379242802812, -122.445445501119) | |||
| 48816 | 48816 | 204541 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 3ft | 5999538.51913 | 2097033.8732 | 37.7380286277303 | -122.444108242518 | (37.7380286277303, -122.444108242518) | |||
| 49107 | 49107 | 8839 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | |||
| 49543 | 49543 | 175621 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6009441.92296 | 2090030.92164 | 37.7193600015446 | -122.409373050849 | (37.7193600015446, -122.409373050849) | |||
| 52871 | 52871 | 113504 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 3x3 | 6011150.15882 | 2090569.3770299999 | 37.7209340525347 | -122.403506146294 | (37.7209340525347, -122.403506146294) | |||
| 53874 | 53874 | 222177 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 4ft | 6003006.81083 | 2100070.04416 | 37.7465624978721 | -122.432333431547 | (37.7465624978721, -122.432333431547) | |||
| 54400 | 54400 | 204527 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999174.36675 | 2097015.2976799998 | 37.737956842928 | -122.44536595789101 | (37.737956842928, -122.445365957891) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");