trees
402 rows where Fire Prevention Districts = 2 and qSpecies_id = 97 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129099 | 10222 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375-1377 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005868.37697 | 2101019.32612 | 37.7493308512387 | -122.422505871374 | (37.7493308512387, -122.422505871374) | 2 | 4 | 5 | 28859 | 19 | |||
47834 | 106690 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 98X CHATTANOOGA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 4x4 | 6004701 | 2103385 | 37.7557605147563 | -122.426711131232 | (37.7557605147563, -122.426711131232) | 2 | 4 | 5 | 28862 | 22 | |||
443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
170717 | 107384 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
74245 | 107997 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | 2 | 4 | 5 | 28862 | 3 | ||||
184258 | 114015 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 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 | ||||
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 | ||||
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 | ||||
118466 | 116773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||||
165184 | 121141 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 100x Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x6 | 6010389 | 2099533 | 37.7455037145463 | -122.406768648836 | (37.7455037145463, -122.406768648836) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
120716 | 1351 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999796.36324 | 2099302.32917 | 37.7442719740833 | -122.443379644158 | (37.7442719740833, -122.443379644158) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
173711 | 173681 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010317 | 2099454 | 37.7452827689443 | -122.407012047483 | (37.7452827689443, -122.407012047483) | 2 | 7 | 7 | 28859 | 2 | ||||
74301 | 1923 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 78 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6001189.66062 | 2097346.80979 | 37.7389819342562 | -122.438421854409 | (37.7389819342562, -122.438421854409) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
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 | |||
194157 | 224494 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 140 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005454.36959 | 2096149.25289 | 37.7359353702183 | -122.423591316208 | (37.7359353702183, -122.423591316208) | 2 | 7 | 7 | 28859 | 2 | |||
189791 | 224495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005480.01407 | 2096145.74782 | 37.7359271935727 | -122.423502403815 | (37.7359271935727, -122.423502403815) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
135750 | 224497 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 826 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007559.62386 | 2095519.19474 | 37.7343239766775 | -122.416267983001 | (37.7343239766775, -122.416267983001) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
9437 | 224500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 39 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007142.18582 | 2099226.02061 | 37.7444786166914 | -122.417973892579 | (37.7444786166914, -122.417973892579) | 2 | 7 | 7 | 28859 | 2 | |||
131252 | 224501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 41 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007129.62294 | 2099203.46046 | 37.7444159645172 | -122.418015733552 | (37.7444159645172, -122.418015733552) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
3598 | 224504 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 995x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.7404258641556 | -122.41539707591 | (37.7404258641556, -122.41539707591) | 2 | 7 | 7 | 28859 | 2 | |||
184443 | 224505 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | 2 | 4 | 7 | 28859 | 19 | |||
172434 | 224506 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2404 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008170.5791 | 2104405.7281 | 37.7587587509332 | -122.414784412782 | (37.7587587509332, -122.414784412782) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
130469 | 224509 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008178.36373 | 2105370.35117 | 37.76140782184 | -122.414825759103 | (37.76140782184, -122.414825759103) | 2 | 4 | 7 | 28859 | 19 | |||
4606 | 224510 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007627.97792 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | 2 | 4 | 7 | 28859 | 19 | |||
50814 | 224511 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | 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 | |||
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 | |||
130133 | 224514 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007856.97968 | 2105196.19408 | 37.7609115633303 | -122.415924962689 | (37.7609115633303, -122.415924962689) | 2 | 4 | 7 | 28859 | 19 | |||
144639 | 224515 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007854.81877 | 2105216.20423 | 37.7609663850986 | -122.415933853387 | (37.7609663850986, -122.415933853387) | 2 | 4 | 7 | 28859 | 19 | |||
155433 | 224516 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007854.68212 | 2105234.63682 | 37.7610169890562 | -122.415935631324 | (37.7610169890562, -122.415935631324) | 2 | 4 | 7 | 28859 | 19 | |||
137057 | 224517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007852.87657 | 2105322.21505 | 37.7612573571568 | -122.415948077947 | (37.7612573571568, -122.415948077947) | 2 | 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 | |||
31709 | 224519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007848.49243 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | 2 | 4 | 7 | 28859 | 19 | |||
51797 | 224520 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007846.93969 | 2105383.76914 | 37.7614260366957 | -122.41597297028 | (37.7614260366957, -122.41597297028) | 2 | 4 | 7 | 28859 | 19 | |||
28050 | 224521 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007845.31387 | 2105404.79187 | 37.7614836688504 | -122.415980082123 | (37.7614836688504, -122.415980082123) | 2 | 4 | 7 | 28859 | 19 | |||
163673 | 224522 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007847.20121 | 2105421.64723 | 37.7615300558868 | -122.415974748238 | (37.7615300558868, -122.415974748238) | 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 | |||
159096 | 224524 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | 2 | 4 | 7 | 28859 | 19 | |||
44250 | 224525 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006711.81921 | 2102941.19607 | 37.7546554124388 | -122.419725571382 | (37.7546554124388, -122.419725571382) | 2 | 4 | 7 | 28859 | 19 | |||
10092 | 224526 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | 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 | |||
165930 | 224528 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006752.85457 | 2102173.99446 | 37.7525511643191 | -122.419529232289 | (37.7525511643191, -122.419529232289) | 2 | 4 | 7 | 28859 | 19 | |||
6967 | 224529 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3035 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6008772.64154 | 2102127.57906 | 37.7525372787939 | -122.412541157349 | (37.7525372787939, -122.412541157349) | 2 | 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 | |||
24922 | 224531 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008520.36157 | 2102113.23947 | 37.752483743936 | -122.413412573453 | (37.752483743936, -122.413412573453) | 2 | 4 | 7 | 28859 | 19 | |||
3962 | 224532 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.414869623533 | (37.7523850181574, -122.414869623533) | 2 | 4 | 7 | 28859 | 19 | |||
6491 | 224533 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | 2 | 4 | 7 | 28859 | 19 | |||
11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
15856 | 224535 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007823.33257 | 2102073.06201 | 37.7523342649139 | -122.415820179079 | (37.7523342649139, -122.415820179079) | 2 | 4 | 7 | 28859 | 19 | |||
1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
128820 | 224538 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008618.62403 | 2103873.92813 | 37.7573237135349 | -122.413197256868 | (37.7573237135349, -122.413197256868) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
181644 | 224540 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008691.13752 | 2103878.13413 | 37.7573393329509 | -122.412946773194 | (37.7573393329509, -122.412946773194) | 2 | 4 | 7 | 28859 | 19 | |||
193316 | 224541 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008764.83764 | 2103880.48748 | 37.7573499314791 | -122.412692054597 | (37.7573499314791, -122.412692054597) | 2 | 4 | 7 | 28859 | 19 | |||
159135 | 224542 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008789.37213 | 2103883.03365 | 37.7573582996747 | -122.412607384336 | (37.7573582996747, -122.412607384336) | 2 | 4 | 7 | 28859 | 19 | |||
122708 | 224543 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006596.43863 | 2103760.05569 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
57933 | 224547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007651.432 | 2104404.91293 | 37.758727329511 | -122.416579809432 | (37.758727329511, -122.416579809432) | 2 | 4 | 7 | 28859 | 19 | |||
3882 | 224548 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007664.7835 | 2104406.99539 | 37.7587337983464 | -122.416533781209 | (37.7587337983464, -122.416533781209) | 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 | |||
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 | |||
173490 | 224551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007716.60877 | 2104410.35168 | 37.7587459283935 | -122.416354782871 | (37.7587459283935, -122.416354782871) | 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 | |||
168856 | 224553 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007749.4839 | 2104412.62357 | 37.7587540151064 | -122.416241246156 | (37.7587540151064, -122.416241246156) | 2 | 4 | 7 | 28859 | 19 | |||
56103 | 224554 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3363 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007798.32865 | 2104414.86293 | 37.7587629102964 | -122.416072476661 | (37.7587629102964, -122.416072476661) | 2 | 4 | 7 | 28859 | 19 | |||
134531 | 224555 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3361 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007814.31661 | 2104415.71368 | 37.7587661451722 | -122.416017243027 | (37.7587661451722, -122.416017243027) | 2 | 4 | 7 | 28859 | 19 | |||
154534 | 224556 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | 2 | 4 | 7 | 28859 | 19 | |||
150111 | 224557 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3349 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007922.95054 | 2104420.26311 | 37.758784744042 | -122.415641857896 | (37.758784744042, -122.415641857896) | 2 | 4 | 7 | 28859 | 19 | |||
185967 | 224558 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3349 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007935.38501 | 2104420.89222 | 37.7587871703981 | -122.415598898179 | (37.7587871703981, -122.415598898179) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
131116 | 224560 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3103 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008678.9898 | 2105047.11608 | 37.7605484090025 | -122.413071439898 | (37.7605484090025, -122.413071439898) | 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 | |||
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 | |||
33250 | 224563 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3121 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008575.93906 | 2105040.68247 | 37.7605249582808 | -122.413427391562 | (37.7605249582808, -122.413427391562) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
171147 | 224566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007859.47136 | 2105581.02762 | 37.7619683674619 | -122.415943597538 | (37.7619683674619, -122.415943597538) | 2 | 4 | 7 | 28859 | 19 | |||
153563 | 224567 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.415816764337 | (37.7619780702545, -122.415816764337) | 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 | |||
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 | |||
22276 | 224570 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007990.36824 | 2105589.83292 | 37.7619999031047 | -122.415491498431 | (37.7619999031047, -122.415491498431) | 2 | 4 | 7 | 28859 | 19 | |||
166779 | 224571 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008059.06529 | 2105594.02225 | 37.7620152671241 | -122.415254197918 | (37.7620152671241, -122.415254197918) | 2 | 4 | 7 | 28859 | 19 | |||
180591 | 224572 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3149 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008508.49482 | 2105618.39976 | 37.7621074503316 | -122.413701514835 | (37.7621074503316, -122.413701514835) | 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 | |||
187780 | 224574 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008595.85169 | 2105623.97585 | 37.7621276661759 | -122.4133997743 | (37.7621276661759, -122.4133997743) | 2 | 4 | 7 | 28859 | 19 | |||
127341 | 224575 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008614.79517 | 2105624.76629 | 37.7621309001374 | -122.413334311737 | (37.7621309001374, -122.413334311737) | 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 | |||
192225 | 224577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3137 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008697.40376 | 2105629.55646 | 37.7621486905358 | -122.413048937978 | (37.7621486905358, -122.413048937978) | 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) );