trees
255 rows where Neighborhoods (old) = 10 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192634 | 244321 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 255 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005987.0957 | 2110521.4851 | 37.7754282408756 | -122.422770539085 | (37.7754282408756, -122.422770539085) | 7 | 9 | 11 | 28852 | 10 | |||
192358 | 10629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.7759254847018 | -122.429965440473 | (37.7759254847018, -122.429965440473) | 7 | 9 | 11 | 29492 | 10 | ||
192110 | 140209 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
192060 | 244242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
189603 | 244508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 470 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003685.2048 | 2109943.0159 | 37.7737097618778 | -122.430692031876 | (37.7737097618778, -122.430692031876) | 7 | 9 | 11 | 29492 | 10 | |||
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 | ||
188275 | 59956 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | 7 | 9 | 11 | 28852 | 10 | ||
188166 | 7161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | 7 | 9 | 11 | 29492 | 10 | |||
187565 | 33694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.7770914710207 | -122.424910846803 | (37.7770914710207, -122.424910846803) | 7 | 9 | 11 | 28852 | 10 | ||
186831 | 16865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | 7 | 9 | 11 | 28852 | 10 | |||
185720 | 139434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 406 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005390.0639 | 2111164.7368 | 37.7771607499747 | -122.424881589077 | (37.7771607499747, -122.424881589077) | 7 | 9 | 11 | 28852 | 10 | |||
185324 | 57510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
182947 | 33693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.424853261184 | (37.7771015944949, -122.424853261184) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
181551 | 244967 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 290 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005160.4976 | 2110090.7807 | 37.7741989587748 | -122.425599278654 | (37.7741989587748, -122.425599278654) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
177953 | 16896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 377 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005209.3255 | 2110233.2837 | 37.7745929962798 | -122.425440517449 | (37.7745929962798, -122.425440517449) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
177613 | 244504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) | 7 | 9 | 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 | |||
176648 | 140610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | 7 | 9 | 11 | 29492 | 10 | |||
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 | |||
175132 | 244244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | 7 | 9 | 11 | 28852 | 10 | |||
174691 | 108010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6005279.8436 | 2111122.0196 | 37.7770372327377 | -122.42525983588 | (37.7770372327377, -122.42525983588) | 7 | 9 | 11 | 28852 | 10 | ||||
173051 | 140068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.7775192332012 | -122.426224448803 | (37.7775192332012, -122.426224448803) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
170449 | 10636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | 7 | 9 | 11 | 29492 | 10 | ||
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 | |||
169233 | 68430 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
167006 | 112132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003600.3374 | 2110567.9569 | 37.7754208875098 | -122.431030213476 | (37.7754208875098, -122.431030213476) | 7 | 9 | 11 | 29492 | 10 | |||
166492 | 247345 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 604 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004033.5399 | 2110118.9664 | 37.7742126072073 | -122.429499636998 | (37.7742126072073, -122.429499636998) | 7 | 9 | 11 | 29492 | 10 | |||
166303 | 33642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005737 | (37.776111096903, -122.42556005737) | 7 | 9 | 11 | 28852 | 10 | |
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 | |||
165292 | 66381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524 | -122.431045702786 | (37.775493505524, -122.431045702786) | 7 | 9 | 11 | 29492 | 10 | |
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 | |||
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 | ||
159706 | 244974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | 7 | 9 | 11 | 28852 | 10 | |||
158884 | 111730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.423429315645 | (37.7772839590018, -122.423429315645) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | ||
157841 | 12247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.426224546997 | (37.7757881731565, -122.426224546997) | 7 | 9 | 11 | 28852 | 10 | |||
157202 | 140051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | 7 | 9 | 11 | 28852 | 10 | |||
156612 | 140631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 810 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003522.9612 | 2111140.977 | 37.7769898742733 | -122.431338789049 | (37.7769898742733, -122.431338789049) | 7 | 9 | 11 | 29492 | 10 | |||
156143 | 108009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.425299350558 | (37.7770313396992, -122.425299350558) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
155347 | 10637 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.430277327931 | (37.7758893402664, -122.430277327931) | 7 | 9 | 11 | 29492 | 10 | ||
154521 | 138978 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 716 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6003068.5257 | 2110892.0599 | 37.7762806451334 | -122.432893033286 | (37.7762806451334, -122.432893033286) | 15 | 9 | 11 | 29492 | 10 | |||
154408 | 67469 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 13 | Permit Number 30990 | 6001172.0898 | 2110442.123 | 37.774937486349 | -122.439421053126 | (37.774937486349, -122.439421053126) | 15 | 5 | 11 | 29492 | 10 | |
153624 | 142119 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1208 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6002005.9378 | 2110874.6586 | 37.7761725398973 | -122.43656756597 | (37.7761725398973, -122.43656756597) | 15 | 5 | 11 | 29492 | 10 | |||
153516 | 142124 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1221 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001940.0404 | 2111161.7753 | 37.776957145428 | -122.436816080775 | (37.776957145428, -122.436816080775) | 15 | 5 | 11 | 29492 | 10 | |||
153383 | 142173 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000881.5899 | 2110372.1418 | 37.7747287989922 | -122.440420931638 | (37.7747287989922, -122.440420931638) | 15 | 5 | 11 | 29492 | 10 | |||
152841 | 140214 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003589.5295 | 2110658.3502 | 37.7756684727789 | -122.43107405366 | (37.7756684727789, -122.43107405366) | 7 | 9 | 11 | 29492 | 10 | |||
150634 | 254387 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001170.9258 | 2110090.9457 | 37.7739731755059 | -122.439399901379 | (37.7739731755059, -122.439399901379) | 15 | 5 | 11 | 29492 | 10 | ||||
149806 | 7172 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003478.684 | 2111101.7087 | 37.7768795438362 | -122.431489153471 | (37.7768795438362, -122.431489153471) | 15 | 9 | 11 | 29492 | 10 | ||
149737 | 139284 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 855 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003447.6659 | 2111322.7123 | 37.7774846068582 | -122.431612236467 | (37.7774846068582, -122.431612236467) | 15 | 9 | 11 | 29492 | 10 | |||
149114 | 247438 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002224.5888 | 2109990.6164 | 37.7737576031752 | -122.435747929432 | (37.7737576031752, -122.435747929432) | 15 | 5 | 11 | 29492 | 10 | |||
149100 | 60603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631 | -122.431018929857 | (37.775379238631, -122.431018929857) | 7 | 9 | 11 | 29492 | 10 | |
145097 | 247439 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 430 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002222.1913 | 2110011.395 | 37.7738145198575 | -122.435757709689 | (37.7738145198575, -122.435757709689) | 15 | 5 | 11 | 29492 | 10 | |||
144711 | 7176 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.7770932936782 | -122.431536884374 | (37.7770932936782, -122.431536884374) | 15 | 9 | 11 | 29492 | 10 | |||
144651 | 7159 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 719 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003516.9027 | 2110817.5612 | 37.7761015111675 | -122.431336655161 | (37.7761015111675, -122.431336655161) | 15 | 9 | 11 | 29492 | 10 | |||
144570 | 58783 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | 7 | 9 | 11 | 28852 | 10 | |
142979 | 141344 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1391 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001208.1693 | 2110371.5133 | 37.7747456630859 | -122.439291184524 | (37.7747456630859, -122.439291184524) | 15 | 5 | 11 | 29492 | 10 | |||
142037 | 140723 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 555 PIERCE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002602.535 | 2110423.8561 | 37.7749686327575 | -122.434471537714 | (37.7749686327575, -122.434471537714) | 15 | 5 | 11 | 29492 | 10 | |||
140575 | 7160 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6003546.1461 | 2110964.158 | 37.7765056869903 | -122.431245960959 | (37.7765056869903, -122.431245960959) | 7 | 9 | 11 | 29492 | 10 | |||
140176 | 140213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 658 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003592.9683 | 2110633.2956 | 37.7755998738913 | -122.431060369379 | (37.7755998738913, -122.431060369379) | 7 | 9 | 11 | 29492 | 10 | |||
138710 | 245220 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.7741913919096 | -122.425893994936 | (37.7741913919096, -122.425893994936) | 7 | 9 | 11 | 28852 | 10 | |||
138681 | 16953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 643 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003890.8551 | 2110044.9948 | 37.7740014196611 | -122.429987931494 | (37.7740014196611, -122.429987931494) | 7 | 9 | 11 | 29492 | 10 | |||
138159 | 114879 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000868 | 2110394 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | 15 | 5 | 11 | 29492 | 10 | ||||
136206 | 16992 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 1x1 | 6002640.9603 | 2109924.6842 | 37.773600211727 | -122.434302921546 | (37.773600211727, -122.434302921546) | 15 | 5 | 11 | 29492 | 10 | |||
133022 | 245850 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 381 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005186.7592 | 2110228.7704 | 37.7745793288374 | -122.42551825752 | (37.7745793288374, -122.42551825752) | 7 | 9 | 11 | 28852 | 10 | |||
132720 | 244480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 436 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004459.1128 | 2109828.0982 | 37.7734380404188 | -122.428006772012 | (37.7734380404188, -122.428006772012) | 7 | 9 | 11 | 28852 | 10 | |||
132386 | 113054 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003823 | 2108493 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | 15 | 9 | 5 | 29492 | 10 | ||||
129493 | 139435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 408 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005375.9537 | 2111162.1376 | 37.7771528162036 | -122.424930215803 | (37.7771528162036, -122.424930215803) | 7 | 9 | 11 | 28852 | 10 | |||
129362 | 142178 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 400 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000706.3548 | 2110383.9675 | 37.7747512900532 | -122.441027952483 | (37.7747512900532, -122.441027952483) | 15 | 5 | 11 | 29492 | 10 | |||
128250 | 111732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.7772931610788 | -122.423339818124 | (37.7772931610788, -122.423339818124) | 7 | 9 | 11 | 28852 | 10 | |||
127425 | 140707 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 PIERCE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002654.7462 | 2110357.8493 | 37.7747903581014 | -122.434286208176 | (37.7747903581014, -122.434286208176) | 15 | 5 | 11 | 29492 | 10 | |||
126179 | 7171 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | 15 | 9 | 11 | 29492 | 10 | ||
125623 | 140061 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 448 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005605.1155 | 2111378.5953 | 37.7777600978209 | -122.42415286955 | (37.7777600978209, -122.42415286955) | 7 | 9 | 11 | 28852 | 10 | |||
125577 | 140609 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 850 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003501.1005 | 2111292.4942 | 37.777404664022 | -122.431425230844 | (37.777404664022, -122.431425230844) | 7 | 9 | 11 | 29492 | 10 | |||
124018 | 141586 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1301 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001472.6683 | 2111100.3675 | 37.776761961586 | -122.438428460489 | (37.776761961586, -122.438428460489) | 15 | 5 | 11 | 29492 | 10 | |||
123680 | 140224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003614.5841 | 2110462.3343 | 37.7751316811611 | -122.430973390858 | (37.7751316811611, -122.430973390858) | 7 | 9 | 11 | 29492 | 10 | |||
123624 | 141652 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1444 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000879.6247 | 2110722.6324 | 37.7756910458411 | -122.440452872246 | (37.7756910458411, -122.440452872246) | 15 | 5 | 11 | 29492 | 10 | |||
123463 | 24490 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 852 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003356.8582 | 2110371.9538 | 37.7748689119653 | -122.431858466675 | (37.7748689119653, -122.431858466675) | 15 | 9 | 11 | 29492 | 10 | ||
122397 | 140223 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003617.0405 | 2110448.5788 | 37.7750940511339 | -122.43096391169 | (37.7750940511339, -122.43096391169) | 7 | 9 | 11 | 29492 | 10 | |||
122196 | 108005 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | 7 | 9 | 11 | 28852 | 10 | |||
120999 | 244926 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005428.5225 | 2110104.1516 | 37.774250812984 | -122.424673083057 | (37.774250812984, -122.424673083057) | 7 | 9 | 11 | 28852 | 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) );