Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188745 | 188745 | 49797 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1145 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 13 | 3x3 | Permit Number 46589 | 6008423.5727699995 | 2115887.46945 | 37.7902991118549 | -122.41472199441999 | (37.7902991118549, -122.41472199442) |
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | |||
| 188019 | 188019 | 190672 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013276.0134 | 2111408.93876 | 37.778273542017395 | -122.39761853578001 | (37.7782735420174, -122.39761853578) | |||
| 187193 | 187193 | 190669 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013237.11478 | 2111370.50988 | 37.7781658589921 | -122.39775040518101 | (37.7781658589921, -122.397750405181) | |||
| 186641 | 186641 | 228467 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004207.05311 | 2107076.17172 | 37.7658676543027 | -122.428682472728 | (37.7658676543027, -122.428682472728) | |||
| 186493 | 186493 | 228463 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 246 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006676.82806 | 2104669.9679099997 | 37.7594002490446 | -122.419969252575 | (37.7594002490446, -122.419969252575) | |||
| 186052 | 186052 | 228495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004273.17296 | 2105900.1551200002 | 37.762642336504705 | -122.42836995111999 | (37.7626423365047, -122.42836995112) | |||
| 183998 | 183998 | 228468 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 305 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004204.63343 | 2107110.4699 | 37.765961691906796 | -122.42869328709101 | (37.7659616919068, -122.428693287091) | |||
| 182749 | 182749 | 228503 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007243.83648 | 2109064.60146 | 37.7714988123571 | -122.418319846488 | (37.7714988123571, -122.418319846488) | |||
| 182542 | 182542 | 228508 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006756.01858 | 2109446.24098 | 37.7725192316996 | -122.420034325725 | (37.7725192316996, -122.420034325725) | |||
| 181692 | 181692 | 228475 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004951.6216 | 2109548.73886 | 37.772698838907 | -122.426283219097 | (37.772698838907, -122.426283219097) | |||
| 181483 | 181483 | 120833 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989987.953 | 2110566.55394 | 37.7746363029346 | -122.478118044214 | (37.7746363029346, -122.478118044214) | |||
| 180413 | 180413 | 228448 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 353 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004452.39919 | 2109432.87501 | 37.7723524740195 | -122.42800182623002 | (37.7723524740195, -122.42800182623) | |||
| 179503 | 179503 | 228469 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 251 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004187.68386 | 2107403.8081400003 | 37.766766168745896 | -122.428772825825 | (37.7667661687459, -122.428772825825) | |||
| 178475 | 178475 | 219179 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.46366964095199 | (37.7551443576498, -122.463669640952) | |||
| 176976 | 176976 | 34454 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 881 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 14 | Permit Number 38198 | 6008682.269119999 | 2120023.6323700002 | 37.8016705265302 | -122.414119665415 | (37.8016705265302, -122.414119665415) | |
| 175553 | 175553 | 228486 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 62 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009328.577269999 | 2097075.3639 | 37.7386961926807 | -122.41026195063 | (37.7386961926807, -122.41026195063) | |||
| 174866 | 174866 | 228507 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006742.36606 | 2109459.07113 | 37.772553691019894 | -122.420082461948 | (37.7725536910199, -122.420082461948) | |||
| 174253 | 174253 | 190654 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 330 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.89819 | 2105464.4496299997 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | |||
| 174174 | 174174 | 228474 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 214 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004967.29881 | 2109550.52085 | 37.772704617954105 | -122.42622911677601 | (37.7727046179541, -122.426229116776) | |||
| 173298 | 173298 | 228431 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 270 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006055.135530001 | 2108039.7727 | 37.7686178926417 | -122.42235880430799 | (37.7686178926417, -122.422358804308) | |||
| 172245 | 172245 | 190653 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 320 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012892.66651 | 2105479.7779900003 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | |||
| 169842 | 169842 | 219181 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999211.06214 | 2094946.2543900001 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | |||
| 169717 | 169717 | 228491 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004217.2996 | 2105758.4451200003 | 37.762250072909104 | -122.428553095368 | (37.7622500729091, -122.428553095368) | |||
| 168299 | 168299 | 228470 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 245 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004187.12028 | 2107418.48366 | 37.766806432287 | -122.42877582146299 | (37.766806432287, -122.428775821463) | |||
| 168166 | 168166 | 228462 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 227 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007175.76045 | 2107902.73822 | 37.768304778378294 | -122.418472926402 | (37.7683047783783, -122.418472926402) | |||
| 167443 | 167443 | 67430 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1803 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30932 | 5989942.29027 | 2110566.40136 | 37.774633233377706 | -122.4782759878 | (37.7746332333777, -122.4782759878) | |
| 167422 | 167422 | 78131 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2040 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53996 | 6000457.66404 | 2121004.4785 | 37.8038982794373 | -122.442650952296 | (37.8038982794373, -122.442650952296) |
| 167042 | 167042 | 228432 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 300 Church St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004140.61494 | 2107068.90552 | 37.7658439427747 | -122.42891175039301 | (37.7658439427747, -122.428911750393) | |||
| 166771 | 166771 | 228450 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.764209660560205 | -122.41109273536699 | (37.7642096605602, -122.411092735367) | |||
| 165639 | 165639 | 228444 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 399 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004268.91864 | 2109406.8209700002 | 37.772270553861496 | -122.428634644993 | (37.7722705538615, -122.428634644993) | |||
| 165619 | 165619 | 228447 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 365 Haight St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004400.01174 | 2109424.0096400003 | 37.7723251679145 | -122.428182407399 | (37.7723251679145, -122.428182407399) | |||
| 165141 | 165141 | 35462 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.39286369422301 | (37.7536788925865, -122.392863694223) | |
| 162506 | 162506 | 190651 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012696.96101 | 2105116.13755 | 37.760962664614 | -122.399179866755 | (37.760962664614, -122.399179866755) | |||
| 161804 | 161804 | 34455 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1711 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 7 | Permit Number 38199 | 6008299.19736 | 2118343.4802 | 37.7970357237711 | -122.415326264207 | (37.7970357237711, -122.415326264207) | |
| 161698 | 161698 | 228439 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 589 Haight St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003347.45965 | 2109278.2341 | 37.7718652941806 | -122.43181286889099 | (37.7718652941806, -122.431812868891) | |||
| 161401 | 161401 | 228484 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000983.78885 | 2101507.81072 | 37.750395343677795 | -122.439431853304 | (37.7503953436778, -122.439431853304) | |||
| 161281 | 161281 | 244228 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 500 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003580.1475 | 2109359.8483 | 37.7721025743544 | -122.431013811567 | (37.7721025743544, -122.431013811567) | |||
| 161170 | 161170 | 67435 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2632 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 6 | Permit Number 30937 | 5990433.164530001 | 2112001.81298 | 37.7786029615899 | -122.47668286606199 | (37.7786029615899, -122.476682866062) | |
| 161130 | 161130 | 244138 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004318.4145 | 2109467.7034 | 37.7724405231997 | -122.428467774696 | (37.7724405231997, -122.428467774696) | |||
| 160550 | 160550 | 228458 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1332 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009514.46513 | 2101394.10676 | 37.7505649315368 | -122.409924021381 | (37.7505649315368, -122.409924021381) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 159768 | 159768 | 228465 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 321 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004210.24642 | 2107036.07535 | 37.7657577400449 | -122.42866856921101 | (37.7657577400449, -122.428668569211) | |||
| 159222 | 159222 | 228434 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 292 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004130.46793 | 2107245.14017 | 37.7663272663153 | -122.428959412666 | (37.7663272663153, -122.428959412666) | |||
| 157193 | 157193 | 228478 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 99 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998158.0059 | 2106821.83124 | 37.7648250972209 | -122.44958643847299 | (37.7648250972209, -122.449586438473) | |||
| 156740 | 156740 | 67426 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1502 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 7 | Permit Number 30928 | 5990903.71531 | 2110660.74638 | 37.7749480428024 | -122.474957149423 | (37.7749480428024, -122.474957149423) | |
| 156471 | 156471 | 190673 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6013287.80421 | 2111419.1855200003 | 37.7783023338298 | -122.397578465593 | (37.7783023338298, -122.397578465593) | |||
| 156077 | 156077 | 246383 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006970.497 | 2109128.1185 | 37.771657824727 | -122.419269850794 | (37.771657824727, -122.419269850794) | |||
| 155900 | 155900 | 228461 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005355.14245 | 2107219.1964 | 37.766325275216296 | -122.424721643507 | (37.7663252752163, -122.424721643507) | |||
| 155607 | 155607 | 228471 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 237 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004185.6843 | 2107453.8801 | 37.7669035410995 | -122.428783311922 | (37.7669035410995, -122.428783311922) | |||
| 154443 | 154443 | 245065 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | |||
| 154238 | 154238 | 190663 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1360 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016747.40621 | 2097393.1689400002 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | |||
| 153625 | 153625 | 244495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 462 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003934.2301 | 2109407.8865 | 37.7722545326532 | -122.42979243828199 | (37.7722545326532, -122.429792438282) | |||
| 153340 | 153340 | 32442 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 11 | Permit Number 36965 | 6001246.93122 | 2105801.18273 | 37.7621988754027 | -122.43882951888901 | (37.7621988754027, -122.438829518889) | |
| 153175 | 153175 | 228452 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.41095401853799 | (37.7642171069559, -122.410954018538) | |||
| 152814 | 152814 | 247323 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 752 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002559.2743 | 2109218.8363 | 37.771657491274205 | -122.434535006264 | (37.7716574912742, -122.434535006264) | |||
| 149630 | 149630 | 228454 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | |||
| 148748 | 148748 | 246382 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006956.341 | 2109096.7729 | 37.77157095990471 | -122.41931659334999 | (37.7715709599047, -122.41931659335) | |||
| 148393 | 148393 | 228505 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006699.63588 | 2109500.73575 | 37.772665684492395 | -122.420233227899 | (37.7726656844924, -122.420233227899) | |||
| 147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
| 146861 | 146861 | 228492 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003450.5613 | 2103629.24333 | 37.756360373235204 | -122.431052978634 | (37.7563603732352, -122.431052978634) | |||
| 146757 | 146757 | 129085 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008098.74192 | 2115839.1342 | 37.790148139064 | -122.41584246517701 | (37.790148139064, -122.415842465177) | |||
| 146693 | 146693 | 190665 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | |||
| 146097 | 146097 | 122810 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1801 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005422.0 | 2107198.0 | 37.7662708507612 | -122.424488887708 | (37.7662708507612, -122.424488887708) | ||||
| 146061 | 146061 | 91218 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 421 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6004113.6375400005 | 2109346.83608 | 37.772097060860794 | -122.42916749825301 | (37.7720970608608, -122.429167498253) | ||
| 145340 | 145340 | 93231 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004092.0 | 2108018.0 | 37.7684471751421 | -122.42914757826 | (37.7684471751421, -122.42914757826) | ||
| 144411 | 144411 | 91216 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 451 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 6003988.48556 | 2109346.1480900003 | 37.7720880862632 | -122.429600359958 | (37.7720880862632, -122.429600359958) | ||
| 144149 | 144149 | 93235 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004170.4 | 2105921.7 | 37.7626956775589 | -122.428726941839 | (37.7626956775589, -122.428726941839) | ||
| 143858 | 143858 | 93234 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 306 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2012 12:00:00 AM | 3 | 3x3 | 6004157.4 | 2107119.9 | 37.7659849113858 | -122.428857330216 | (37.7659849113858, -122.428857330216) | ||
| 143449 | 143449 | 93309 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 309 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 6004203.0 | 2107120.0 | 37.7659877668224 | -122.428699616217 | (37.7659877668224, -122.428699616217) | ||
| 143377 | 143377 | 32828 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.43724693926201 | (37.7511683628484, -122.437246939262) | ||
| 142789 | 142789 | 39301 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 141850 | 141850 | 27324 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 320 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:31:00 AM | 3 | 4x4 | 6004588.93351 | 2109631.91786 | 37.7729067207461 | -122.42754372417801 | (37.7729067207461, -122.427543724178) | ||
| 141131 | 141131 | 93307 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 445 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 07:00:00 AM | 3 | 3x3 | 6004245.0 | 2106273.0 | 37.763664485103895 | -122.42849396833701 | (37.7636644851039, -122.428493968337) | ||
| 140879 | 140879 | 93306 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 465 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004251.0 | 2106168.0 | 37.7633765197798 | -122.428465731621 | (37.7633765197798, -122.428465731621) | ||
| 140863 | 140863 | 36113 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1251 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39210 | 5991731.11313688 | 2106919.21929981 | 37.764722731307394 | -122.47182229152901 | (37.7647227313074, -122.471822291529) | ||
| 140820 | 140820 | 10265 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 212 Haight St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005102.223809999 | 2109572.2105099997 | 37.7727717979426 | -122.42576394022 | (37.7727717979426, -122.42576394022) | |||
| 140495 | 140495 | 30691 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 20 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52599 | 6006108.61199537 | 2109713.28983155 | 37.773215986766296 | -122.422292750625 | (37.7732159867663, -122.422292750625) | ||
| 140307 | 140307 | 91207 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 391 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2007 12:00:00 AM | 3 | 3x3 | 6004300.94327 | 2109389.6362 | 37.7722251810056 | -122.428522643794 | (37.7722251810056, -122.428522643794) | ||
| 140076 | 140076 | 49200 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 3x3 | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |
| 139885 | 139885 | 91116 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3838 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2009 12:00:00 AM | 3 | 4x4 | Permit Number 52006 | 6004047.0 | 2104828.0 | 37.7596856536801 | -122.429075753932 | (37.7596856536801, -122.429075753932) |
| 139543 | 139543 | 10297 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 540 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2005 12:00:00 AM | 8 | 3X3 | 6003554.89128 | 2109371.3672 | 37.7721327712956 | -122.43110199714701 | (37.7721327712956, -122.431101997147) | ||
| 139363 | 139363 | 93304 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004236.0 | 2105969.0 | 37.7628292645514 | -122.428503426462 | (37.7628292645514, -122.428503426462) | ||
| 138636 | 138636 | 48636 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) |
| 136455 | 136455 | 228479 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 184 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998955.25722 | 2107101.1921200003 | 37.7656377291263 | -122.446849065839 | (37.7656377291263, -122.446849065839) | |||
| 136265 | 136265 | 228501 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004538.94965 | 2097529.04935 | 37.7396722646649 | -122.426854524238 | (37.7396722646649, -122.426854524238) | |||
| 135498 | 135498 | 228476 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.42960322110599 | (37.7434561594686, -122.429603221106) | |||
| 134674 | 134674 | 228506 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 74 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006728.215419999 | 2109473.21902 | 37.7725917404536 | -122.420132414803 | (37.7725917404536, -122.420132414803) | |||
| 134183 | 134183 | 66597 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 14 | Permit Number 29790 | 6008070.415030001 | 2115836.67012 | 37.7901397807808 | -122.415940299715 | (37.7901397807808, -122.415940299715) | |
| 132848 | 132848 | 95250 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001050.95383 | 2119955.94053 | 37.8010530753849 | -122.440522591565 | (37.8010530753849, -122.440522591565) | |
| 132350 | 132350 | 228436 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 160 Church St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004092.7276 | 2107966.58323 | 37.768306038331794 | -122.42914139496 | (37.7683060383318, -122.42914139496) | |||
| 131234 | 131234 | 228502 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 157 Randall St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6004514.7040099995 | 2097528.46975 | 37.739669302297294 | -122.426938314049 | (37.7396693022973, -122.426938314049) | |||
| 130323 | 130323 | 228477 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003665.88299 | 2100131.59167 | 37.74676884190679 | -122.43005882127599 | (37.7467688419068, -122.430058821276) | |||
| 130008 | 130008 | 95251 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Avila St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767151 | 6001052.92994 | 2119937.28939 | 37.801001976825 | -122.440514414928 | (37.801001976825, -122.440514414928) | |
| 129356 | 129356 | 91196 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 430 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 6 | 3x3 | 6004046.01956 | 2109450.8286599996 | 37.772378771061 | -122.42940881154199 | (37.772378771061, -122.429408811542) | ||
| 128886 | 128886 | 6821 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 128858 | 128858 | 66456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 144 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2008 12:00:00 AM | 3x3 | Permit Number 51700 | 6009019.86661618 | 2097810.11966481 | 37.7406963622889 | -122.41138122330099 | (37.7406963622889, -122.411381223301) | ||
| 128623 | 128623 | 94420 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 127802 | 127802 | 49192 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 127481 | 127481 | 35764 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3321 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2003 12:00:00 AM | Permit Number 39025 | 6006713.03914548 | 2106101.29867165 | 37.7633323895219 | -122.41994558786999 | (37.7633323895219, -122.41994558787) |
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");