Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189077 | 189077 | 192894 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 345 04th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012507.03144 | 2112612.14811 | 37.781534427998295 | -122.400363278337 | (37.7815344279983, -122.400363278337) | |||
| 189041 | 189041 | 130818 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2205 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6003521.30137 | 2117210.30876 | 37.79365463619661 | -122.431777984168 | (37.7936546361966, -122.431777984168) | |||
| 188979 | 188979 | 208590 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 5993420.78428 | 2104324.2280599996 | 37.757695183915104 | -122.465789652393 | (37.7576951839151, -122.465789652393) | |||
| 188956 | 188956 | 45565 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3561 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 6 | Permit Number 44309 | 5997197.65372 | 2116007.3067900003 | 37.789991026609705 | -122.45357132096001 | (37.7899910266097, -122.45357132096) | |
| 188879 | 188879 | 142843 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1437 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006701.0162 | 2115860.8988 | 37.79012922270321 | -122.420680041355 | (37.7901292227032, -122.420680041355) | |||
| 188856 | 188856 | 67711 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 522 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 5 | Permit Number 31322 | 6014581.76234 | 2112965.60005 | 37.7826204034479 | -122.393210388247 | (37.7826204034479, -122.393210388247) | |
| 188846 | 188846 | 208565 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1839 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993732.590419999 | 2102966.8371900003 | 37.7539861198715 | -122.46461274467899 | (37.7539861198715, -122.464612744679) | |||
| 188843 | 188843 | 130469 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Green St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001711.466080001 | 2118055.39023 | 37.7958722519592 | -122.438100719995 | (37.7958722519592, -122.438100719995) | |||
| 188813 | 188813 | 130885 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 900 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007000.43823 | 2114072.44349 | 37.785235434998796 | -122.41951712471399 | (37.7852354349988, -122.419517124714) | |||
| 188765 | 188765 | 192981 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 706 De Haro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012076.86726 | 2105068.00252 | 37.7607959195066 | -122.40132113006901 | (37.7607959195066, -122.401321130069) | ||||
| 188737 | 188737 | 229684 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1295 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009275.06342 | 2101646.66956 | 37.7512449925854 | -122.410769729433 | (37.7512449925854, -122.410769729433) | |||
| 188622 | 188622 | 130726 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2990 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999309.06264 | 2117371.2757099997 | 37.7938569351133 | -122.446364217934 | (37.7938569351133, -122.446364217934) | |||
| 188600 | 188600 | 138013 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1798 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004955.7517 | 2115053.8167 | 37.7878146599783 | -122.426661024671 | (37.7878146599783, -122.426661024671) | |||
| 188599 | 188599 | 208656 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 531 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5996910.34793 | 2093819.89449 | 37.7290535330719 | -122.452963156224 | (37.7290535330719, -122.452963156224) | |||
| 188591 | 188591 | 208779 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 211 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5994996.60783 | 2100599.99204 | 37.7475601499859 | -122.46007004689501 | (37.7475601499859, -122.460070046895) | |||
| 188540 | 188540 | 229379 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 York St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009777.24977 | 2105744.0136700002 | 37.7625235234694 | -122.40932222476499 | (37.7625235234694, -122.409322224765) | |||
| 188477 | 188477 | 124506 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2875 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995886.284419999 | 2111020.06012 | 37.7762221167636 | -122.45774749290399 | (37.7762221167636, -122.457747492904) | |||
| 188425 | 188425 | 130511 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3870 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5996298.86533 | 2115600.22493 | 37.7888217253879 | -122.456651580816 | (37.7888217253879, -122.456651580816) | |||
| 188323 | 188323 | 230613 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 354 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002830.435740001 | 2101547.6226 | 37.7506095783815 | -122.43304886743601 | (37.7506095783815, -122.433048867436) | |||
| 188307 | 188307 | 130455 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2800 Divisadero St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000633.845509999 | 2117965.67172 | 37.79556456422021 | -122.441823037297 | (37.7955645642202, -122.441823037297) | |||
| 188285 | 188285 | 230230 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 218 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003716.849780001 | 2109193.27433 | 37.77165294805479 | -122.43052905969401 | (37.7716529480548, -122.430529059694) | |||
| 188241 | 188241 | 230606 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4018 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003024.10503 | 2101853.78577 | 37.7514612138691 | -122.432401008424 | (37.7514612138691, -122.432401008424) | |||
| 188220 | 188220 | 130506 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1553 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003905.97865 | 2120395.8588799997 | 37.802423134070295 | -122.430674391923 | (37.8024231340703, -122.430674391923) | |||
| 188201 | 188201 | 229634 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 355 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008822.1262 | 2097155.6085900003 | 37.7388881250791 | -122.41201869441099 | (37.7388881250791, -122.412018694411) | |||
| 188198 | 188198 | 79435 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 1 | 6004044.7014 | 2110862.9754 | 37.776256105061606 | -122.429514097991 | (37.7762561050616, -122.429514097991) | ||
| 188125 | 188125 | 230078 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 708 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007439.789969999 | 2097741.86515 | 37.740420201123904 | -122.416839707211 | (37.7404202011239, -122.416839707211) | |||
| 188101 | 188101 | 230461 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1332 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009253.10704 | 2101351.7655700003 | 37.7504340208338 | -122.41082483179899 | (37.7504340208338, -122.410824831799) | |||
| 188077 | 188077 | 69403 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33507 | 6001071.30066 | 2087381.77877 | 37.7116134968267 | -122.438117445581 | (37.7116134968267, -122.438117445581) | |
| 188016 | 188016 | 192869 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Bonifacio St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012653.96554 | 2112821.67449 | 37.782117931539204 | -122.399869671075 | (37.7821179315392, -122.399869671075) | |||
| 187994 | 187994 | 230787 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 250 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003973.32737 | 2104534.4557 | 37.7588754802432 | -122.429309618557 | (37.7588754802432, -122.429309618557) | |||
| 187974 | 187974 | 78598 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 535 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | 6008370.91308 | 2114317.1343900003 | 37.785984394913 | -122.41479301119699 | (37.785984394913, -122.414793011197) | ||
| 187946 | 187946 | 230092 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 60 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006858.30015 | 2099488.97253 | 37.7451846420554 | -122.41897415993799 | (37.7451846420554, -122.418974159938) | |||
| 187928 | 187928 | 48397 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3919 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45779 | 5995985.21505 | 2115508.15533 | 37.7885509137416 | -122.457730095228 | (37.7885509137416, -122.457730095228) | |
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 187868 | 187868 | 177360 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 229 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6003864.95037 | 2092317.2930400001 | 37.7253238242224 | -122.428813475161 | (37.7253238242224, -122.428813475161) | |||
| 187863 | 187863 | 230856 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 67 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001476.34226 | 2107837.46661 | 37.767803059184 | -122.438181953041 | (37.767803059184, -122.438181953041) | |||
| 187842 | 187842 | 57867 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2078 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53494 | 6003110.24385 | 2118247.73617 | 37.7964798348222 | -122.433274440777 | (37.7964798348222, -122.433274440777) | |
| 187825 | 187825 | 230586 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 510 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003045.274069999 | 2102727.93705 | 37.7538626267631 | -122.43239023094999 | (37.7538626267631, -122.43239023095) | |||
| 187823 | 187823 | 230546 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005822.224640001 | 2099912.9687799998 | 37.746290443053496 | -122.422586859801 | (37.7462904430535, -122.422586859801) | |||
| 187804 | 187804 | 52942 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 71 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | Permit Number 48929 | 6002252.43026 | 2093269.9255099997 | 37.727848138461 | -122.434455877432 | (37.727848138461, -122.434455877432) | |
| 187776 | 187776 | 130708 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2878 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5999898.82899 | 2117101.58457 | 37.793150100339204 | -122.444304187712 | (37.7931501003392, -122.444304187712) | |||
| 187772 | 187772 | 192822 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 674 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6013416.27051 | 2113057.4659700003 | 37.7828078293482 | -122.397248962085 | (37.7828078293482, -122.397248962085) | |||
| 187764 | 187764 | 229314 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1320 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007147.46213 | 2107772.9111 | 37.7679467105963 | -122.41856160045401 | (37.7679467105963, -122.418561600454) | |||
| 187746 | 187746 | 230512 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 303 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006209.378219999 | 2101362.60843 | 37.750292657291205 | -122.42135105461901 | (37.7502926572912, -122.421351054619) | |||
| 187745 | 187745 | 130546 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 151 Spruce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997046.49747 | 2115779.30522 | 37.7893563291674 | -122.454077831739 | (37.7893563291674, -122.454077831739) | |||
| 187707 | 187707 | 177361 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 239 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004077.07419 | 2092152.3659599999 | 37.724882974752 | -122.428068435432 | (37.724882974752, -122.428068435432) | |||
| 187678 | 187678 | 130799 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2624 Steiner St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6002200.357969999 | 2117124.26521 | 37.7933434159171 | -122.43634239249599 | (37.7933434159171, -122.436342392496) | |||
| 187676 | 187676 | 58061 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1726 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1977 12:00:00 AM | 11 | Permit Number 17031 | 5999586.8326 | 2114838.9116 | 37.786919589274504 | -122.445220957582 | (37.7869195892745, -122.445220957582) | ||
| 187610 | 187610 | 141541 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 52 KITTREDGE TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998005.5327 | 2111427.171 | 37.77746145563 | -122.450445824391 | (37.77746145563, -122.450445824391) | |||
| 187572 | 187572 | 230665 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 943 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003800.07693 | 2102751.11196 | 37.7539690309724 | -122.42978160074 | (37.7539690309724, -122.42978160074) | |||
| 187521 | 187521 | 230165 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 44 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003839.28778 | 2106889.40135 | 37.7653340073945 | -122.42994117196999 | (37.7653340073945, -122.42994117197) | |||
| 187481 | 187481 | 57664 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1806 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1976 12:00:00 AM | 7 | Permit Number 16566 | 6001568.8356 | 2114688.8156 | 37.786620397604295 | -122.438352937221 | (37.7866203976043, -122.438352937221) | ||
| 187452 | 187452 | 67020 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 149 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 6 | Permit Number 32112 | 5990819.4847800005 | 2114429.04391 | 37.785289865300996 | -122.475523724044 | (37.785289865301, -122.475523724044) | |
| 187442 | 187442 | 130755 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2692 Broadway | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6000824.66047 | 2117166.5962799997 | 37.793381383496204 | -122.44110542868601 | (37.7933813834962, -122.441105428686) | |||
| 187422 | 187422 | 193117 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1789 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014368.11598 | 2096649.52963 | 37.737808141841 | -122.39280769161999 | (37.737808141841, -122.39280769162) | |||
| 187398 | 187398 | 68529 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 614 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 10 | Permit Number 32410 | 5994730.36077 | 2111314.5868 | 37.776964335760496 | -122.461767479865 | (37.7769643357605, -122.461767479865) | |
| 187389 | 187389 | 192940 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1531 Howard St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007930.12579 | 2109464.25147 | 37.772634764912205 | -122.415974234728 | (37.7726347649122, -122.415974234728) | |||
| 187323 | 187323 | 208662 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 187 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000834.12273 | 2094623.43205 | 37.7314839437143 | -122.43945596951 | (37.7314839437143, -122.43945596951) | |||
| 187303 | 187303 | 44110 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2355 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | 8 | Permit Number 43620 | 6002314.9262 | 2117740.34461 | 37.7950415194118 | -122.43599008309401 | (37.7950415194118, -122.435990083094) | ||
| 187288 | 187288 | 229609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005773.99218 | 2096107.35427 | 37.7358383621589 | -122.42248327588999 | (37.7358383621589, -122.42248327589) | |||
| 187267 | 187267 | 230449 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 201 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007699.4283 | 2100337.86039 | 37.7475628263773 | -122.4161257831 | (37.7475628263773, -122.4161257831) | |||
| 187252 | 187252 | 38795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 667 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | 4 | Permit Number 40643 | 6013193.0271 | 2113622.9268 | 37.7843480231413 | -122.398060977557 | (37.7843480231413, -122.398060977557) | |
| 187249 | 187249 | 98829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 21 | 3x3 | 6008023.617869999 | 2119295.81426 | 37.7996351035429 | -122.41634732658702 | (37.7996351035429, -122.416347326587) | |||
| 187205 | 187205 | 229341 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2384 Bryant St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6009657.1451900005 | 2103466.25311 | 37.7562625782597 | -122.409576854282 | (37.7562625782597, -122.409576854282) | |||
| 187191 | 187191 | 230252 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 85 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004316.63271 | 2097687.7392 | 37.7400954181634 | -122.427634504424 | (37.7400954181634, -122.427634504424) | |||
| 187190 | 187190 | 199672 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1903 Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015218.7957 | 2093426.4678 | 37.729005478352 | -122.389641411418 | (37.729005478352, -122.389641411418) | |||
| 187144 | 187144 | 229399 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 720 York St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009836.02304 | 2104660.9662099998 | 37.759553013267 | -122.40904252568701 | (37.759553013267, -122.409042525687) | |||
| 187131 | 187131 | 73537 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Huntington Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1995 12:00:00 AM | 5 | 5984627.56608 | 2094712.4640000002 | 37.7307927427943 | -122.495490862808 | (37.7307927427943, -122.495490862808) | ||
| 187080 | 187080 | 192864 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Tandang Sora St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012596.11924 | 2112706.04983 | 37.781797227899396 | -122.40006167180701 | (37.7817972278994, -122.400061671807) | |||
| 187065 | 187065 | 245184 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1200 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000751.2481 | 2109310.6513 | 37.7718067907455 | -122.44079564934201 | (37.7718067907455, -122.440795649342) | |||
| 187056 | 187056 | 230448 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 193 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007646.20782 | 2100322.13851 | 37.74751666506621 | -122.416308703407 | (37.7475166650662, -122.416308703407) | |||
| 187025 | 187025 | 182471 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1558 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985932.6077 | 2104630.0492 | 37.7581000932694 | -122.49170899036699 | (37.7581000932694, -122.491708990367) | |||
| 187017 | 187017 | 208734 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1722 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990620.476559999 | 2103641.60792 | 37.7556589596157 | -122.47542432686899 | (37.7556589596157, -122.475424326869) | |||
| 186995 | 186995 | 113704 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 401 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5985902.45226 | 2113130.43743 | 37.7814380033373 | -122.492439252398 | (37.7814380033373, -122.492439252398) | ||||
| 186989 | 186989 | 130964 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 127 Trenton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010053.962280001 | 2118064.7842599996 | 37.796368959215705 | -122.409234648782 | (37.7963689592157, -122.409234648782) | |||
| 186940 | 186940 | 230756 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000987.12796 | 2104906.74039 | 37.7597281715484 | -122.43966395125 | (37.7597281715484, -122.43966395125) | |||
| 186920 | 186920 | 229442 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3119 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009084.862319999 | 2100391.9832900004 | 37.7477892369773 | -122.41133884113998 | (37.7477892369773, -122.41133884114) | |||
| 186859 | 186859 | 123006 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 14 06th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993959.7605 | 2115469.14519 | 37.7883272380259 | -122.464734969158 | (37.7883272380259, -122.464734969158) | |||
| 186855 | 186855 | 230436 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 252 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008078.013590001 | 2100229.9878 | 37.7472879117277 | -122.414809020947 | (37.7472879117277, -122.414809020947) | |||
| 186843 | 186843 | 95615 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1536 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2011 12:00:00 AM | 15 | 3x3 | Permit Number 767385 | 6006783.64356 | 2117713.2414700002 | 37.795219951190006 | -122.420525698205 | (37.79521995119, -122.420525698205) | |
| 186801 | 186801 | 208660 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 451 Hearst Ave | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 1ft | 5998589.90723 | 2094352.40559 | 37.730611791998705 | -122.44719512135599 | (37.7306117919987, -122.447195121356) | |||
| 186767 | 186767 | 230694 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 530 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003606.59668 | 2105141.60912 | 37.7605218097625 | -122.430621268061 | (37.7605218097625, -122.430621268061) | |||
| 186732 | 186732 | 130855 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2461 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004938.44378 | 2118069.3435299997 | 37.7960935571235 | -122.42693575820299 | (37.7960935571235, -122.426935758203) | |||
| 186730 | 186730 | 65409 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 566 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1989 12:00:00 AM | 20 | Permit Number 28260 | 6014074.51061 | 2104461.51409 | 37.7592418847137 | -122.39436965303999 | (37.7592418847137, -122.39436965304) | ||
| 186696 | 186696 | 193301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1252 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016734.51502 | 2093904.2827400002 | 37.7304013937892 | -122.384434670625 | (37.7304013937892, -122.384434670625) | |||
| 186657 | 186657 | 230220 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 267 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999308.36964 | 2105934.14707 | 37.7624534815661 | -122.44554380420601 | (37.7624534815661, -122.445543804206) | |||
| 186633 | 186633 | 230782 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 279 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002100.0363 | 2104236.83976 | 37.7579520671607 | -122.43576702784901 | (37.7579520671607, -122.435767027849) | |||
| 186630 | 186630 | 36960 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 40 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 4 | Permit Number 39590 | 5994276.373459999 | 2115318.71773 | 37.787932453726604 | -122.463628626536 | (37.7879324537266, -122.463628626536) | |
| 186624 | 186624 | 230083 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007029.65592 | 2097573.32988 | 37.7399343630818 | -122.41824584668001 | (37.7399343630818, -122.41824584668) | |||
| 186604 | 186604 | 230470 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 483 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008980.97531 | 2106006.41262 | 37.7631993657816 | -122.41209480313101 | (37.7631993657816, -122.412094803131) | |||
| 186590 | 186590 | 142889 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.047 | 2114753.8909 | 37.7871010363106 | -122.419902442274 | (37.7871010363106, -122.419902442274) | |||
| 186586 | 186586 | 229646 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 86 Montezuma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6007872.20159 | 2099757.75291 | 37.745979694004795 | -122.415487277913 | (37.7459796940048, -122.415487277913) | |||
| 186581 | 186581 | 137703 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 724 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000074.0452 | 2111365.0813 | 37.7774091440624 | -122.443285717245 | (37.7774091440624, -122.443285717245) | |||
| 186570 | 186570 | 250652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986706.54079 | 2115175.99151 | 37.7871014859956 | -122.489808017137 | (37.7871014859956, -122.489808017137) | |||
| 186546 | 186546 | 230075 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 710 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007486.86917 | 2097737.12894 | 37.7404098445288 | -122.41667658998001 | (37.7404098445288, -122.41667658998) | |||
| 186543 | 186543 | 130459 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2160 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002737.0956 | 2118196.26596 | 37.7963173354181 | -122.434561930911 | (37.7963173354181, -122.434561930911) | |||
| 186528 | 186528 | 192826 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 351 Saint Francis Pl | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6013220.105769999 | 2113174.2529599997 | 37.7831175765455 | -122.397935809387 | (37.7831175765455, -122.397935809387) | |||
| 186522 | 186522 | 229469 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1504 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6005210.33202 | 2099558.38444 | 37.745282295845705 | -122.42467749307501 | (37.7452822958457, -122.424677493075) | |||
| 186521 | 186521 | 193261 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1033 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010360.11976 | 2111787.0965400003 | 37.779149076112205 | -122.40773240503701 | (37.7791490761122, -122.407732405037) | |||
| 186470 | 186470 | 229478 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1679 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004645.28511 | 2099111.09847 | 37.7440222224549 | -122.426599487283 | (37.7440222224549, -122.426599487283) |
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");