Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 54902 | 54902 | 204547 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 68 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.738869316670204 | -122.443488741839 | (37.7388693166702, -122.443488741839) | |||
| 55688 | 55688 | 113505 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | 3x3 | 6011134.8090699995 | 2090561.37437 | 37.72091122147071 | -122.403558643321 | (37.7209112214707, -122.403558643321) | |||
| 56104 | 56104 | 222180 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 4ft | 6003010.48164 | 2100075.576 | 37.7465778951541 | -122.432321133307 | (37.7465778951541, -122.432321133307) | |||
| 56579 | 56579 | 204560 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999598.12734 | 2097466.8336099996 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | |||
| 57712 | 57712 | 204535 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999462.01157 | 2097038.1578 | 37.738036027335895 | -122.444373073979 | (37.7380360273359, -122.444373073979) | |||
| 63932 | 63932 | 204528 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 3ft | 5999178.73464 | 2097017.09345 | 37.7379620230245 | -122.44535098508301 | (37.7379620230245, -122.445350985083) | |||
| 66335 | 66335 | 204517 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 3ft | 5998995.15377 | 2096935.4716400001 | 37.7377274276678 | -122.445979843191 | (37.7377274276678, -122.445979843191) | |||
| 67188 | 67188 | 204553 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 64 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999694.8834 | 2097395.01803 | 37.7390291648714 | -122.443593551518 | (37.7390291648714, -122.443593551518) | |||
| 68371 | 68371 | 204555 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5999635.81986 | 2097444.2193400003 | 37.7391608912586 | -122.443801299384 | (37.7391608912586, -122.443801299384) | |||
| 68755 | 68755 | 222178 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 4ft | 6003005.10045 | 2100073.32596 | 37.7465714119449 | -122.432339580201 | (37.7465714119449, -122.432339580201) | |||
| 68873 | 68873 | 175623 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6009402.84406 | 2090023.10643 | 37.719336352976 | -122.409507581334 | (37.719336352976, -122.409507581334) | |||
| 69230 | 69230 | 222176 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 4ft | 6002985.78905 | 2100071.06849 | 37.7465641184368 | -122.432406195695 | (37.7465641184368, -122.432406195695) | |||
| 74641 | 74641 | 205772 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5999313.6439 | 2097558.6392200002 | 37.7394566791949 | -122.444923457253 | (37.7394566791949, -122.444923457253) | |||
| 76402 | 76402 | 8742 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3300 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | |||
| 76804 | 76804 | 175626 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 41 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6009096.33692 | 2089936.65243 | 37.7190817890677 | -122.410560964424 | (37.7190817890677, -122.410560964424) | |||
| 77881 | 77881 | 8945 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4800 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | |||
| 78178 | 78178 | 8812 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3800 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | |||
| 78744 | 78744 | 8832 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | |||
| 81104 | 81104 | 8880 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4200 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.46426453234699 | (37.7810917943038, -122.464264532347) | |||
| 81207 | 81207 | 8745 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3300 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | |||
| 82073 | 82073 | 8933 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4600 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | |||
| 82536 | 82536 | 9051 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | |||
| 83161 | 83161 | 8838 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | |||
| 83654 | 83654 | 8676 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | |||
| 84440 | 84440 | 8675 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2900 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | |||
| 84928 | 84928 | 8884 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4200 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.46426453234699 | (37.7810917943038, -122.464264532347) |
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");