trees
309 rows where Supervisor Districts = 7 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59124 | 226494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008770.52865 | 2104997.08999 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | 2 | 4 | 7 | 28859 | 19 | |||
59644 | 224508 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008177.84488 | 2105327.19464 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | 2 | 4 | 7 | 28859 | 19 | |||
59992 | 224513 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | 2 | 4 | 7 | 28859 | 19 | |||
60878 | 224499 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 35 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6007169.2602 | 2099278.27912 | 37.744623630583 | -122.417883978366 | (37.744623630583, -122.417883978366) | 2 | 7 | 7 | 28859 | 2 | |||
61058 | 166227 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007587.23887 | 2102689.09416 | 37.7540124736145 | -122.416680268187 | (37.7540124736145, -122.416680268187) | 2 | 4 | 7 | 28859 | 19 | |||
61132 | 38252 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1556 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 24 | 4x6 | Permit Number 40362 | 6007050.76125355 | 2107358.39166569 | 37.7668030933038 | -122.418866676369 | (37.7668030933038, -122.418866676369) | 8 | 4 | 7 | 28853 | 19 | |
61290 | 576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3008 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008852.23919 | 2102169.31321 | 37.7526563382221 | -122.412268843556 | (37.7526563382221, -122.412268843556) | 2 | 4 | 7 | 28859 | 19 | |||
62255 | 226479 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008278.21403 | 2105065.65299 | 37.7605768005893 | -122.414458856385 | (37.7605768005893, -122.414458856385) | 2 | 4 | 7 | 28859 | 19 | |||
62588 | 114016 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
62941 | 224711 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3287 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006422.59039 | 2103751.13112 | 37.7568630097384 | -122.420783300913 | (37.7568630097384, -122.420783300913) | 2 | 4 | 7 | 28859 | 19 | |||
63376 | 224523 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007845.69064 | 2105448.2985 | 37.7616031491907 | -122.415981860092 | (37.7616031491907, -122.415981860092) | 2 | 4 | 7 | 28859 | 19 | |||
64252 | 224549 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007677.21195 | 2104407.32973 | 37.7587354153184 | -122.416490821491 | (37.7587354153184, -122.416490821491) | 2 | 4 | 7 | 28859 | 19 | |||
65040 | 622 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3150 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007969.89189 | 2102118.08704 | 37.7524661316063 | -122.415316538925 | (37.7524661316063, -122.415316538925) | 2 | 4 | 7 | 28859 | 19 | |||
65251 | 116393 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
65463 | 224530 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008605.15504 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | 2 | 4 | 7 | 28859 | 19 | |||
65684 | 65243 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.7545136503205 | -122.411231929366 | (37.7545136503205, -122.411231929366) | 2 | 4 | 7 | 28859 | 19 | ||
67261 | 224653 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 44 Elsie St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6007416.47838 | 2099024.91557 | 37.7439418608428 | -122.417011196208 | (37.7439418608428, -122.417011196208) | 2 | 7 | 7 | 28859 | 2 | |||
67398 | 224635 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007212.97385 | 2098214.14312 | 37.7417042108849 | -122.417657415761 | (37.7417042108849, -122.417657415761) | 2 | 7 | 7 | 28859 | 2 | |||
68038 | 224544 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3275 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006493.53291 | 2103755.09983 | 37.7568779051989 | -122.420538236555 | (37.7568779051989, -122.420538236555) | 2 | 4 | 7 | 28859 | 19 | |||
69695 | 226478 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008300.96502 | 2105069.13983 | 37.7605876527244 | -122.41438041754 | (37.7605876527244, -122.41438041754) | 2 | 4 | 7 | 28859 | 19 | |||
71250 | 224573 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3145 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008576.89617 | 2105622.59644 | 37.7621228143258 | -122.413465236845 | (37.7621228143258, -122.413465236845) | 2 | 4 | 7 | 28859 | 19 | |||
71345 | 224503 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 111 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006785.20384 | 2096905.74889 | 37.7380875710875 | -122.419043723383 | (37.7380875710875, -122.419043723383) | 2 | 7 | 7 | 28859 | 2 | |||
71622 | 224643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006383.19422 | 2098395.08711 | 37.742154314365 | -122.420539363423 | (37.742154314365, -122.420539363423) | 2 | 7 | 7 | 28859 | 2 | |||
73278 | 224630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 661 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007657.44331 | 2096273.95417 | 37.7364018809509 | -122.415983219874 | (37.7364018809509, -122.415983219874) | 2 | 7 | 7 | 28859 | 2 | |||
74599 | 224486 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | 2 | 7 | 7 | 28859 | 2 | |||
74671 | 116392 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
74854 | 224496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 822 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007561.99234 | 2095547.7778 | 37.7344025926964 | -122.416261818137 | (37.7344025926964, -122.416261818137) | 2 | 7 | 7 | 28859 | 2 | |||
75503 | 224564 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3147 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008554.61838 | 2105039.35143 | 37.7605201064243 | -122.413501036147 | (37.7605201064243, -122.413501036147) | 2 | 4 | 7 | 28859 | 19 | |||
76052 | 48037 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
78946 | 226484 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6008470.16955 | 2105663.03593 | 37.7622278587398 | -122.413837225211 | (37.7622278587398, -122.413837225211) | 8 | 4 | 7 | 28859 | 19 | |||
79503 | 656 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6007336.00672 | 2102041.77073 | 37.7522209377618 | -122.417503217111 | (37.7522209377618, -122.417503217111) | 2 | 4 | 7 | 28859 | 19 | |||
79542 | 226495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1850 Harrison St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008685.71484 | 2107616.88585 | 37.7676047820563 | -122.413229904031 | (37.7676047820563, -122.413229904031) | 8 | 4 | 7 | 28853 | 19 | |||
80081 | 655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.417559493969 | (37.7522209377659, -122.417559493969) | 2 | 4 | 7 | 28859 | 19 | ||
80194 | 224568 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007934.38254 | 2105585.38385 | 37.7619845399816 | -122.415684816721 | (37.7619845399816, -122.415684816721) | 2 | 4 | 7 | 28859 | 19 | |||
80807 | 224710 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006579.99639 | 2103217.61904 | 37.755406979455 | -122.420201068142 | (37.755406979455, -122.420201068142) | 2 | 4 | 7 | 28859 | 19 | |||
80884 | 60279 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 890 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1982 12:00:00 AM | Permit Number 19841 | 6007951.11915857 | 2102749.5563076 | 37.7541989479338 | -122.415426159541 | (37.7541989479338, -122.415426159541) | 2 | 4 | 7 | 28859 | 19 | ||
82252 | 48042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
82623 | 224638 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 150 Kingston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006127.41253 | 2098099.44281 | 37.7413281233964 | -122.421402787214 | (37.7413281233964, -122.421402787214) | 2 | 7 | 7 | 28859 | 2 | |||
82624 | 224655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 144 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006439.43826 | 2097444.91016 | 37.7395485107564 | -122.42027746554 | (37.7395485107564, -122.42027746554) | 2 | 7 | 7 | 28859 | 2 | |||
82787 | 630 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3176 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6007837.40103 | 2102111.35303 | 37.7524401942684 | -122.415774239015 | (37.7524401942684, -122.415774239015) | 2 | 4 | 7 | 28859 | 19 | |||
83060 | 224550 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007700.02344 | 2104409.21878 | 37.7587418850474 | -122.416412062475 | (37.7587418850474, -122.416412062475) | 2 | 4 | 7 | 28859 | 19 | |||
83716 | 114018 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
87855 | 224576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3139 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008637.01425 | 2105626.66822 | 37.7621373698597 | -122.413257598684 | (37.7621373698597, -122.413257598684) | 2 | 4 | 7 | 28859 | 19 | |||
88014 | 224562 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3107 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008636.34218 | 2105044.15954 | 37.7605378968171 | -122.413218729979 | (37.7605378968171, -122.413218729979) | 2 | 4 | 7 | 28859 | 19 | |||
90379 | 105718 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | |||
91606 | 224569 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007968.16087 | 2105588.52083 | 37.7619950521511 | -122.415568212409 | (37.7619950521511, -122.415568212409) | 2 | 4 | 7 | 28859 | 19 | |||
91862 | 58807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 40 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23661 | 6007506.51736783 | 2099215.13200372 | 37.744469217231 | -122.416713333977 | (37.744469217231, -122.416713333977) | 2 | 7 | 7 | 28859 | 2 | ||
92219 | 33508 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | 2 | 7 | 7 | 28859 | 2 | |||
92825 | 224507 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008190.11914 | 2105143.75528 | 37.760786302162 | -122.414769064951 | (37.760786302162, -122.414769064951) | 2 | 4 | 7 | 28859 | 19 | |||
92990 | 114017 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
93830 | 63410 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1987 12:00:00 AM | Permit Number 23993 | 6007543.2306715 | 2095481.74721631 | 37.7342202321398 | -122.416322008236 | (37.7342202321398, -122.416322008236) | 2 | 7 | 7 | 28859 | 2 | ||
94197 | 224654 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 38 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007453.75758 | 2099095.22372 | 37.7441370083106 | -122.416887273228 | (37.7441370083106, -122.416887273228) | 2 | 7 | 7 | 28859 | 2 | |||
95454 | 255584 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 151 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006696 | 2105242 | 37.7609719961735 | -122.41994353943 | (37.7609719961735, -122.41994353943) | 2 | 4 | 7 | 28859 | 19 | ||||
95838 | 226485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544939 | (37.7622371604259, -122.41372544939) | 8 | 4 | 7 | 28859 | 19 | |||
96286 | 224518 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007850.1916 | 2105341.72368 | 37.7613107723984 | -122.415958745694 | (37.7613107723984, -122.415958745694) | 2 | 4 | 7 | 28859 | 19 | |||
96429 | 224485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6007214.09312 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | 8 | 4 | 7 | 28853 | 19 | |||
97647 | 602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3085 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6008423.83472 | 2102105.59165 | 37.7524573245683 | -122.413745839724 | (37.7524573245683, -122.413745839724) | 2 | 4 | 7 | 28859 | 19 | |||
97902 | 48043 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
97958 | 224539 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008666.00775 | 2103876.41315 | 37.7573331968792 | -122.413033560461 | (37.7573331968792, -122.413033560461) | 2 | 4 | 7 | 28859 | 19 | |||
99319 | 176423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009799.11271 | 2092612.10018 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | 10 | 3 | 7 | 309 | 28 | |||
101195 | 226473 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008617.67732 | 2105085.24659 | 37.7606496645635 | -122.413286189004 | (37.7606496645635, -122.413286189004) | 2 | 4 | 7 | 28859 | 19 | |||
101534 | 224552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007727.86688 | 2104411.29924 | 37.7587491632507 | -122.416315914159 | (37.7587491632507, -122.416315914159) | 2 | 4 | 7 | 28859 | 19 | |||
102288 | 224527 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | 2 | 4 | 7 | 28859 | 19 | |||
102347 | 24603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 407 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6007220.87336 | 2097309.53692 | 37.7392208076833 | -122.417566003264 | (37.7392208076833, -122.417566003264) | 2 | 7 | 7 | 28859 | 2 | |||
102657 | 224559 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008699.11003 | 2105047.58808 | 37.7605508344761 | -122.41300188634 | (37.7605508344761, -122.41300188634) | 2 | 4 | 7 | 28859 | 19 | |||
102851 | 176422 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009782.31983 | 2092607.20943 | 37.7264530165924 | -122.408378041837 | (37.7264530165924, -122.408378041837) | 10 | 3 | 7 | 309 | 28 | |||
103250 | 111889 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6011076.19973 | 2092521.56402 | 37.7262902239912 | -122.403899105983 | (37.7262902239912, -122.403899105983) | 10 | 3 | 7 | 309 | 28 | |||
104440 | 224498 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 834 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007554.05965 | 2095454.27722 | 37.7341454144668 | -122.416282623937 | (37.7341454144668, -122.416282623937) | 2 | 7 | 7 | 28859 | 2 | |||
104706 | 224676 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 123 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007744.73276 | 2107219.69106 | 37.766461304874 | -122.416456511479 | (37.766461304874, -122.416456511479) | 8 | 4 | 7 | 28853 | 19 | |||
106068 | 604 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3090 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008414.92242 | 2102144.51738 | 37.7525637053586 | -122.413779413197 | (37.7525637053586, -122.413779413197) | 2 | 4 | 7 | 28859 | 19 | |||
107233 | 224512 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6009423.35212 | 2103670.74387 | 37.756810960566 | -122.41039983289 | (37.756810960566, -122.41039983289) | 2 | 4 | 7 | 28859 | 19 | |||
107337 | 224631 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 667 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007655.79797 | 2096256.88725 | 37.7363549264252 | -122.415987700275 | (37.7363549264252, -122.415987700275) | 2 | 7 | 7 | 28859 | 2 | |||
107405 | 597 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3067 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008545.44191 | 2102115.03145 | 37.7524900724667 | -122.41332596784 | (37.7524900724667, -122.41332596784) | 2 | 4 | 7 | 28859 | 19 | |||
107742 | 121142 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
107780 | 66216 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 438 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29307 | 6008473.34152559 | 2106010.06053059 | 37.7631808865324 | -122.413850803115 | (37.7631808865324, -122.413850803115) | 8 | 4 | 7 | 28859 | 19 | ||
107790 | 613 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008177.96308 | 2102131.82169 | 37.7525155358782 | -122.41459796354 | (37.7525155358782, -122.41459796354) | 2 | 4 | 7 | 28859 | 19 | |||
108034 | 224502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 203 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006664.46693 | 2098372.33412 | 37.7421076872335 | -122.419565194404 | (37.7421076872335, -122.419565194404) | 2 | 7 | 7 | 28859 | 2 | |||
108091 | 644 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3245 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007452.42683 | 2102052.29911 | 37.75225639624 | -122.417101363131 | (37.75225639624, -122.417101363131) | 2 | 4 | 7 | 28859 | 19 | |||
108436 | 224667 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008944.82068 | 2105599.01741 | 37.7620787232758 | -122.412191055786 | (37.7620787232758, -122.412191055786) | 8 | 4 | 7 | 28859 | 19 | |||
108921 | 571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2970 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/30/2015 12:00:00 AM | 12 | 3x3 | 6009054.00613 | 2102184.08314 | 37.7527082129358 | -122.411572138748 | (37.7527082129358, -122.411572138748) | 2 | 4 | 7 | 28859 | 19 | ||
109279 | 68204 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1110 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.7542458964916 | -122.408413088762 | (37.7542458964916, -122.408413088762) | 2 | 4 | 7 | 28859 | 19 |
109507 | 48038 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2005 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | ||
109891 | 224698 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3196 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007749.27916 | 2102109.5588 | 37.7524303134304 | -122.416078852874 | (37.7524303134304, -122.416078852874) | 2 | 4 | 7 | 28859 | 19 | |||
111571 | 224487 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 14 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 6007167.09986 | 2099582.88965 | 37.7454599011682 | -122.41791303725 | (37.7454599011682, -122.41791303725) | 2 | 7 | 7 | 28859 | 2 | |||
111591 | 224669 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.7589657361945 | -122.410724513338 | (37.7589657361945, -122.410724513338) | 2 | 4 | 7 | 28859 | 19 | |||
111931 | 224561 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3105 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008657.35528 | 2105044.9077 | 37.7605411307748 | -122.413146107923 | (37.7605411307748, -122.413146107923) | 2 | 4 | 7 | 28859 | 19 | |||
112423 | 224708 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3018 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6008114.55455 | 2103302.41792 | 37.7557261650385 | -122.414900084483 | (37.7557261650385, -122.414900084483) | 2 | 4 | 7 | 28859 | 19 | |||
112805 | 224672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009346.52184 | 2104406.68388 | 37.7588273781878 | -122.410717513006 | (37.7588273781878, -122.410717513006) | 2 | 4 | 7 | 28859 | 19 | |||
113394 | 224545 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3285 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006448.3388 | 2103753.67154 | 37.756871436376 | -122.420694433515 | (37.756871436376, -122.420694433515) | 2 | 4 | 7 | 28859 | 19 | |||
115554 | 33588 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | 2 | 7 | 7 | 28859 | 2 | |||
115657 | 26548 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3085 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008470.90767 | 2102107.16108 | 37.752464277228 | -122.413583164054 | (37.752464277228, -122.413583164054) | 2 | 4 | 7 | 28859 | 19 | |||
116584 | 224587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008334.82797 | 2106780.39435 | 37.7652882651653 | -122.414384386251 | (37.7652882651653, -122.414384386251) | 8 | 4 | 7 | 28859 | 19 | |||
117537 | 226477 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008318.01409 | 2105071.04935 | 37.7605938535523 | -122.414321587482 | (37.7605938535523, -122.414321587482) | 2 | 4 | 7 | 28859 | 19 | |||
117545 | 224674 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 600 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007862.99313 | 2104382.32986 | 37.7586772175088 | -122.415846532793 | (37.7586772175088, -122.415846532793) | 2 | 4 | 7 | 28859 | 19 | |||
118655 | 625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4x6 | 6007920.1411 | 2102115.05717 | 37.7524550160009 | -122.415488371495 | (37.7524550160009, -122.415488371495) | 2 | 4 | 7 | 28859 | 19 | |||
118944 | 592 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3050 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008558.83929 | 2102157.76802 | 37.752608169649 | -122.413282659187 | (37.752608169649, -122.413282659187) | 2 | 4 | 7 | 28859 | 19 | |||
119887 | 224565 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3149 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008534.1903 | 2105038.29661 | 37.7605160630797 | -122.413571613154 | (37.7605160630797, -122.413571613154) | 2 | 4 | 7 | 28859 | 19 | |||
120282 | 116391 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
120982 | 598 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3070 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6008489.07402 | 2102147.94889 | 37.75257729143 | -122.413523226034 | (37.75257729143, -122.413523226034) | 2 | 4 | 7 | 28859 | 19 | |||
122395 | 224578 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2881 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009009.60186 | 2101733.0677 | 37.7514673346644 | -122.411693832315 | (37.7514673346644, -122.411693832315) | 2 | 4 | 7 | 28859 | 19 |
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) );