trees
531 rows where Fire Prevention Districts = 15 and qSpecies_id = 54 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194022 | 59752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2375 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1981 12:00:00 AM | 11 | Permit Number 19189 | 6000826.215 | 2113783.3508 | 37.7840919573447 | -122.440857239763 | (37.7840919573447, -122.440857239763) | 15 | 6 | 11 | 29490 | 13 | ||
193632 | 248365 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.448430301142 | (37.7687175089215, -122.448430301142) | 15 | 5 | 11 | 29492 | 9 | |||
193449 | 244056 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.7710940655703 | -122.45059866498 | (37.7710940655703, -122.45059866498) | 15 | 5 | 11 | 29492 | 9 | |||
192913 | 142130 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 24 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998647.6806 | 2110905.5745 | 37.7760660175212 | -122.448186864357 | (37.7760660175212, -122.448186864357) | 15 | 6 | 2 | 29492 | 16 | |||
192522 | 8181 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1212 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6001826.5111 | 2111197.1465 | 37.7770478129311 | -122.43721134601 | (37.7770478129311, -122.43721134601) | 15 | 5 | 11 | 29492 | 41 | |||
191893 | 54834 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 109 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 17 | Permit Number 10688 | 5998714.6082 | 2110323.5588 | 37.7744717777818 | -122.447913432558 | (37.7744717777818, -122.447913432558) | 15 | 5 | 11 | 29492 | 16 | ||
191861 | 248318 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998789.7889 | 2108283.5046 | 37.768874606083 | -122.447506493604 | (37.768874606083, -122.447506493604) | 15 | 5 | 11 | 29492 | 9 | |||
191363 | 140422 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6002931.6326 | 2112346.6107 | 37.7802667133087 | -122.433470553427 | (37.7802667133087, -122.433470553427) | 15 | 9 | 11 | 29490 | 41 | |||
191153 | 140423 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.433383957928 | (37.7802799627924, -122.433383957928) | 15 | 9 | 11 | 29490 | 41 | |||
190808 | 7213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003452.6284 | 2111644.2112 | 37.7783676442869 | -122.43161802827 | (37.7783676442869, -122.43161802827) | 15 | 9 | 11 | 29492 | 41 | |||
190613 | 7021 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.436257405533 | (37.7741621348105, -122.436257405533) | 15 | 5 | 11 | 29492 | 10 | |||
190509 | 27413 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.7741328457417 | -122.436473498525 | (37.7741328457417, -122.436473498525) | 15 | 5 | 11 | 29492 | 10 | |||
190495 | 55481 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | 15 | 5 | 11 | 29492 | 10 | ||
189309 | 140143 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745 | (37.7732657172386, -122.45080046745) | 15 | 5 | 11 | 29492 | 16 | |
189104 | 7169 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.7770418043343 | -122.431522126808 | (37.7770418043343, -122.431522126808) | 15 | 9 | 11 | 29492 | 10 | ||
188527 | 247347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999077.9485 | 2109033.7671 | 37.7709511000472 | -122.446563758939 | (37.7709511000472, -122.446563758939) | 15 | 5 | 11 | 29492 | 9 | |||
188191 | 140047 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 997 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Width 0ft | Permit Number 19087 | 6002926.2641 | 2111608.0681 | 37.778238555435 | -122.433436333455 | (37.778238555435, -122.433436333455) | 15 | 9 | 11 | 29492 | 41 | |
187807 | 248407 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 39 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999275.3753 | 2108109.8322 | 37.7684254834855 | -122.445814398115 | (37.7684254834855, -122.445814398115) | 15 | 5 | 11 | 29492 | 9 | |||
187722 | 140048 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 993 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | Permit Number 19087 | 6002927.2794 | 2111591.8239 | 37.7781940105178 | -122.433431660039 | (37.7781940105178, -122.433431660039) | 15 | 9 | 11 | 29492 | 41 | ||
186972 | 246125 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.449279571151 | (37.7688149359981, -122.449279571151) | 15 | 5 | 11 | 29492 | 9 | |
186358 | 247445 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 811 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003098.9445 | 2109936.0688 | 37.7736574554899 | -122.432719499751 | (37.7736574554899, -122.432719499751) | 15 | 5 | 11 | 29492 | 9 | |||
186344 | 140691 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1120 FILLMORE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003358.8311 | 2112311.3938 | 37.7801942444853 | -122.431990162179 | (37.7801942444853, -122.431990162179) | 15 | 9 | 11 | 29490 | 41 | |||
186155 | 16983 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 847 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002927.3278 | 2109904.9371 | 37.7735622410817 | -122.433310922729 | (37.7735622410817, -122.433310922729) | 15 | 5 | 11 | 29492 | 9 | |||
186087 | 140145 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.450657700787 | (37.7732838718856, -122.450657700787) | 15 | 5 | 11 | 29492 | 16 | |||
185363 | 10403 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.7702155954819 | -122.44475781987 | (37.7702155954819, -122.44475781987) | 15 | 5 | 11 | 29492 | 9 | |||
184958 | 140491 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1396 Turk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003381.0328 | 2112450.7507 | 37.7805781423675 | -122.431923310003 | (37.7805781423675, -122.431923310003) | 15 | 9 | 11 | 29490 | 41 | |||
184887 | 137574 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1135 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002846.9387 | 2112168.7066 | 37.7797734277366 | -122.433750829498 | (37.7797734277366, -122.433750829498) | 15 | 9 | 11 | 29490 | 41 | |||
184798 | 140713 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002640.192 | 2110470.3137 | 37.775098331299 | -122.434344596397 | (37.775098331299, -122.434344596397) | 15 | 5 | 11 | 29492 | 10 | |||
184681 | 16981 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 837 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002980.1732 | 2109918.2793 | 37.7736018732822 | -122.433129076252 | (37.7736018732822, -122.433129076252) | 15 | 5 | 11 | 29492 | 9 | |||
183457 | 14559 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1595X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999419.8987 | 2109421.334 | 37.772034786606 | -122.445408819898 | (37.772034786606, -122.445408819898) | 15 | 5 | 11 | 29492 | 9 | |||
183064 | 246151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | 15 | 5 | 11 | 29492 | 9 | |||
182958 | 138718 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1605 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999603.495 | 2114383.6783 | 37.7856705883683 | -122.445130569247 | (37.7856705883683, -122.445130569247) | 15 | 6 | 1 | 29490 | 31 | |||
182946 | 244167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 443 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5997917.5884 | 2109065.1071 | 37.7709708040394 | -122.450579717232 | (37.7709708040394, -122.450579717232) | 15 | 5 | 11 | 29492 | 9 | |||
182944 | 245112 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1511 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999762.5828 | 2109470.1939 | 37.7721884999222 | -122.444226964495 | (37.7721884999222, -122.444226964495) | 15 | 5 | 11 | 29492 | 9 | |||
182746 | 10463 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.448419594554 | (37.7698923436585, -122.448419594554) | 15 | 5 | 11 | 29492 | 9 | |||
182571 | 246085 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999025.5413 | 2108408.7245 | 37.7692318980119 | -122.446700056431 | (37.7692318980119, -122.446700056431) | 15 | 5 | 11 | 29492 | 9 | |||
182384 | 16962 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 729 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003498.0043 | 2109990.6447 | 37.7738299314263 | -122.431342987883 | (37.7738299314263, -122.431342987883) | 15 | 9 | 11 | 29492 | 10 | |||
181995 | 16963 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.431485538257 | (37.7737958222062, -122.431485538257) | 15 | 9 | 11 | 29492 | 10 | |||
181674 | 245078 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1387 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000393.4407 | 2109556.4466 | 37.7724612989944 | -122.442050971779 | (37.7724612989944, -122.442050971779) | 15 | 5 | 11 | 29492 | 9 | |||
181350 | 140504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1020 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003445.3738 | 2111793.5292 | 37.7787772231874 | -122.431653787974 | (37.7787772231874, -122.431653787974) | 15 | 9 | 11 | 29490 | 41 | |||
181278 | 7170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003473.1451 | 2111141.589 | 37.7769887313283 | -122.43151116193 | (37.7769887313283, -122.43151116193) | 15 | 9 | 11 | 29492 | 10 | ||
180949 | 38058 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | 15 | 6 | 1 | 29490 | 31 | |
180542 | 17132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2017 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 5997337.3364 | 2109131.1798 | 37.7711189934376 | -122.452591584143 | (37.7711189934376, -122.452591584143) | 15 | 5 | 11 | 29492 | 9 | |||
179204 | 140428 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.432970381874 | (37.7803281468599, -122.432970381874) | 15 | 9 | 11 | 29490 | 41 | |||
178882 | 16964 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) | 15 | 9 | 11 | 29492 | 10 | |||
178797 | 142102 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Fell St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6003042.617 | 2110331.1771 | 37.7747391304954 | -122.432942578238 | (37.7747391304954, -122.432942578238) | 15 | 5 | 11 | 29492 | 10 | |||
178749 | 59661 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 16 | Permit Number 19083 | 6002974.356 | 2111562.0693 | 37.7781149825494 | -122.433266678398 | (37.7781149825494, -122.433266678398) | 15 | 9 | 11 | 29492 | 41 | ||
178543 | 140710 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002647.4691 | 2110413.42 | 37.7749425283913 | -122.434315354923 | (37.7749425283913, -122.434315354923) | 15 | 5 | 11 | 29492 | 10 | |||
177996 | 17124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1959 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997650.0826 | 2109175.1865 | 37.7712577387998 | -122.451512964016 | (37.7712577387998, -122.451512964016) | 15 | 5 | 11 | 29492 | 9 | |||
177642 | 142107 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1223 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001862.2998 | 2111151.4099 | 37.7769242660631 | -122.437084266624 | (37.7769242660631, -122.437084266624) | 15 | 5 | 11 | 29492 | 10 | |||
177129 | 247502 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002054.0619 | 2110138.0012 | 37.7741525973198 | -122.436348358239 | (37.7741525973198, -122.436348358239) | 15 | 5 | 11 | 29492 | 10 | |||
176134 | 10477 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | 15 | 5 | 11 | 29492 | 9 | |||
176113 | 246089 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | 15 | 5 | 11 | 29492 | 9 | |||
175970 | 141351 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 457 BRODERICK ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 6001146.5934 | 2110320.3656 | 37.7746017201243 | -122.439500520347 | (37.7746017201243, -122.439500520347) | 15 | 5 | 11 | 29492 | 10 | |||
175312 | 142179 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 400 BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000700.9795 | 2110406.5438 | 37.7748129727095 | -122.441048166714 | (37.7748129727095, -122.441048166714) | 15 | 5 | 11 | 29492 | 10 | |||
174803 | 140293 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 135 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998254.8738 | 2110151.3644 | 37.773972687525 | -122.449491324786 | (37.773972687525, -122.449491324786) | 15 | 5 | 11 | 29492 | 16 | |||
174355 | 246165 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.451866631913 | (37.7684868003121, -122.451866631913) | 15 | 5 | 11 | 29492 | 9 | |||
174204 | 140775 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000103.2341 | 2112808.3657 | 37.7813736978278 | -122.443288433233 | (37.7813736978278, -122.443288433233) | 15 | 5 | 1 | 29490 | 16 | |||
173853 | 59660 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 910 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 15 | Permit Number 19082 | 6002982.2355 | 2111513.667 | 37.7779825288987 | -122.43323596098 | (37.7779825288987, -122.43323596098) | 15 | 9 | 11 | 29492 | 41 | ||
172590 | 247448 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002819.5442 | 2109896.0423 | 37.7735317029302 | -122.433683126065 | (37.7735317029302, -122.433683126065) | 15 | 5 | 11 | 29492 | 9 | |||
171824 | 1652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1701X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998816.4722 | 2109337.1138 | 37.7717690739196 | -122.447490047494 | (37.7717690739196, -122.447490047494) | 15 | 5 | 11 | 29492 | 9 | |||
170999 | 110580 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.439406585409 | (37.7740317204292, -122.439406585409) | 15 | 5 | 11 | 29492 | 10 | |||
170938 | 59662 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 911 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 17 | Permit Number 19084 | 6002943.8621 | 2111474.7299 | 37.7778734403922 | -122.433365924976 | (37.7778734403922, -122.433365924976) | 15 | 9 | 11 | 29492 | 41 | ||
170320 | 246043 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 601 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5997853.8956 | 2108495.9392 | 37.7694043689932 | -122.450758987128 | (37.7694043689932, -122.450758987128) | 15 | 5 | 11 | 29492 | 9 | |||
170228 | 7164 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 733 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003503.3323 | 2110918.6468 | 37.7763782981407 | -122.431390816474 | (37.7763782981407, -122.431390816474) | 15 | 9 | 11 | 29492 | 10 | |||
170061 | 140544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | 15 | 9 | 11 | 29490 | 41 | |||
169210 | 17056 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1285 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x4.5 | 6000853.6213 | 2109624.5846 | 37.7726746024779 | -122.440464053818 | (37.7726746024779, -122.440464053818) | 15 | 5 | 11 | 29492 | 9 | |||
169091 | 246094 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | 15 | 5 | 11 | 29492 | 9 | |||
168823 | 246084 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | 15 | 5 | 11 | 29492 | 9 | |||
168798 | 17133 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2021 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5997314.265 | 2109127.7618 | 37.7711082865548 | -122.452671141791 | (37.7711082865548, -122.452671141791) | 15 | 5 | 11 | 29492 | 9 | |||
167294 | 7167 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003488.931 | 2111020.5633 | 37.776657319429 | -122.431447911846 | (37.776657319429, -122.431447911846) | 15 | 9 | 11 | 29492 | 10 | |||
167293 | 7023 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1115 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002035.3214 | 2110135.6586 | 37.7741451002744 | -122.436413017138 | (37.7741451002744, -122.436413017138) | 15 | 5 | 11 | 29492 | 10 | |||
166532 | 247447 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 899 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002801.7546 | 2109893.9494 | 37.7735249469174 | -122.433744513243 | (37.7735249469174, -122.433744513243) | 15 | 5 | 11 | 29492 | 9 | |||
166317 | 247450 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 917 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6002601.5894 | 2109867.0536 | 37.7734397376197 | -122.434434989996 | (37.7734397376197, -122.434434989996) | 15 | 5 | 11 | 29492 | 9 | |||
166099 | 19218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1103X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002097.9849 | 2110143.8576 | 37.7741711731344 | -122.436196840248 | (37.7741711731344, -122.436196840248) | 15 | 5 | 11 | 29492 | 10 | |||
165915 | 7168 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 761 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003490.0388 | 2111001.7309 | 37.7766056731066 | -122.431442734929 | (37.7766056731066, -122.431442734929) | 15 | 9 | 11 | 29492 | 10 | |||
165670 | 61337 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 650 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1984 12:00:00 AM | 10 | 5x6 | Permit Number 21242 | 5999250.392 | 2114334.8634 | 37.7855163948709 | -122.446348686743 | (37.7855163948709, -122.446348686743) | 15 | 6 | 1 | 29490 | 31 | |
164343 | 140777 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 77 TERRA VISTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000158.3968 | 2112814.4573 | 37.7813935692054 | -122.443098035367 | (37.7813935692054, -122.443098035367) | 15 | 5 | 1 | 29490 | 16 | |||
163536 | 141341 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001191.7822 | 2110294.5435 | 37.7745333908239 | -122.439342352417 | (37.7745333908239, -122.439342352417) | 15 | 5 | 11 | 29492 | 10 | |||
163106 | 142113 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1270 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6001736.8029 | 2110836.8034 | 37.7760533014164 | -122.437495863249 | (37.7760533014164, -122.437495863249) | 15 | 5 | 11 | 29492 | 10 | |||
162822 | 140546 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1060 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6002924.6148 | 2111925.6484 | 37.7791104580396 | -122.433464739787 | (37.7791104580396, -122.433464739787) | 15 | 9 | 11 | 29490 | 41 | |||
162060 | 55476 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | 15 | 5 | 11 | 29492 | 10 | ||
162051 | 17670 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1015X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/1995 12:00:00 AM | 12 | 3X3 | 6002378.1109 | 2112076.6861 | 37.7794941484605 | -122.435366123882 | (37.7794941484605, -122.435366123882) | 15 | 5 | 11 | 29490 | 41 | ||
161906 | 140538 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1025 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003370.5162 | 2111893.2524 | 37.7790467948997 | -122.43191987222 | (37.7790467948997, -122.43191987222) | 15 | 9 | 11 | 29490 | 41 | |||
161696 | 244544 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1921 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997795.9759 | 2109196.9758 | 37.7713259200895 | -122.451009886929 | (37.7713259200895, -122.451009886929) | 15 | 5 | 11 | 29492 | 9 | |||
160927 | 247390 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 217 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002281.8171 | 2109227.9509 | 37.7716667634841 | -122.435495398285 | (37.7716667634841, -122.435495398285) | 15 | 5 | 11 | 29492 | 9 | |||
160471 | 248352 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1585 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998007.43 | 2108190.3847 | 37.7685741818657 | -122.450205893283 | (37.7685741818657, -122.450205893283) | 15 | 5 | 11 | 29492 | 9 | |||
159295 | 246092 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 700 Stanyan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997091.8262 | 2108330.4431 | 37.7689063069149 | -122.453382986949 | (37.7689063069149, -122.453382986949) | 15 | 5 | 11 | 29492 | 9 | |||
159022 | 54831 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 79 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1972 12:00:00 AM | 8 | Permit Number 10685 | 6000087.3282 | 2112805.9967 | 37.7813662861419 | -122.443343289517 | (37.7813662861419, -122.443343289517) | 15 | 5 | 1 | 29490 | 16 | ||
158612 | 141687 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2350 TURK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5998550.3836 | 2111804.4075 | 37.778528418096 | -122.448588188719 | (37.778528418096, -122.448588188719) | 15 | 6 | 2 | 54 | 16 | |||
158404 | 139083 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2512 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000143.6633 | 2113744.4727 | 37.7839463117797 | -122.443215821997 | (37.7839463117797, -122.443215821997) | 15 | 6 | 11 | 29490 | 31 | |||
158382 | 246133 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 662 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998546.7685 | 2108359.3633 | 37.7690690038469 | -122.448352544267 | (37.7690690038469, -122.448352544267) | 15 | 5 | 11 | 29492 | 9 | |||
158234 | 142073 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6001163.9737 | 2110159.9703 | 37.774162304079 | -122.439428898655 | (37.774162304079, -122.439428898655) | 15 | 5 | 11 | 29492 | 10 | |||
158222 | 140592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 950 STEINER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002968.2418 | 2111603.9288 | 37.7782295714383 | -122.433290821469 | (37.7782295714383, -122.433290821469) | 15 | 9 | 11 | 29492 | 41 | |||
157958 | 55484 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | 18 | Permit Number 11437 | 6002049.3973 | 2110903.3005 | 37.7762536529278 | -122.436419278446 | (37.7762536529278, -122.436419278446) | 15 | 5 | 11 | 29492 | 10 | ||
157472 | 138742 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2965 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999291.2776 | 2114261.7649 | 37.7853180204784 | -122.446201975075 | (37.7853180204784, -122.446201975075) | 15 | 6 | 1 | 29490 | 31 | |||
157331 | 137592 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | 15 | 9 | 11 | 29490 | 41 | ||
157137 | 45611 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401 | (37.7796667869975, -122.43166374401) | 15 | 9 | 11 | 29490 | 41 | ||
156939 | 17138 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2049 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5997189.9355 | 2109110.6719 | 37.7710542373874 | -122.453099965702 | (37.7710542373874, -122.453099965702) | 15 | 5 | 11 | 29492 | 9 | |||
156129 | 140711 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002645.4844 | 2110432.6051 | 37.7749950932562 | -122.434323592325 | (37.7749950932562, -122.434323592325) | 15 | 5 | 11 | 29492 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );