trees
969 rows where qSpecies_id = 97 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8924 | 224586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.7652964112246 | -122.414261518161 | (37.7652964112246, -122.414261518161) | 8 | 4 | 7 | 28859 | 19 | |||
9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
9655 | 587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3045 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.412706471622 | (37.7525282406021, -122.412706471622) | 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 | |||
10134 | 224679 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007366.73942 | 2101988.35955 | 37.7520760119996 | -122.417393153575 | (37.7520760119996, -122.417393153575) | 2 | 4 | 7 | 28859 | 19 | |||
10260 | 261386 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 31 Abbey St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6004642 | 2106187 | 37.7634508076606 | -122.427114742536 | (37.7634508076606, -122.427114742536) | 8 | 4 | 5 | 28862 | 3 | ||||
11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 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 | |||
11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 | |
11707 | 224712 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3560 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006570.05679 | 2104384.71114 | 37.7586109842303 | -122.420318274095 | (37.7586109842303, -122.420318274095) | 2 | 4 | 7 | 28859 | 19 | |||
13271 | 551 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2900 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6009445.64374 | 2102206.22318 | 37.7527909649347 | -122.41021934346 | (37.7527909649347, -122.41021934346) | 2 | 4 | 7 | 28859 | 19 | |||
13405 | 245415 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010145.3814 | 2102202.4336 | 37.752819757444 | -122.407799244655 | (37.752819757444, -122.407799244655) | 2 | 4 | 7 | 28859 | 19 | |
13764 | 224696 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.7524624264182 | -122.415583660969 | (37.7524624264182, -122.415583660969) | 2 | 4 | 7 | 28859 | 19 | |||
15629 | 66830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.438953746382 | (37.7575293253254, -122.438953746382) | 2 | 4 | 5 | 28862 | 3 | ||
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 | |||
15993 | 226468 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
16341 | 224695 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3034 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6008772.76102 | 2102170.48787 | 37.7526551034509 | -122.412543777077 | (37.7526551034509, -122.412543777077) | 2 | 4 | 7 | 28859 | 19 | |||
16785 | 224704 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007185.41243 | 2102081.52674 | 37.7523216240474 | -122.418026814981 | (37.7523216240474, -122.418026814981) | 2 | 4 | 7 | 28859 | 19 | |||
17311 | 61740 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.429865402911 | (37.7490603587459, -122.429865402911) | 2 | 4 | 5 | 28862 | 22 | ||
17320 | 226492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | 2 | 4 | 7 | 28859 | 19 | |||
17850 | 60829 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 82 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20508 | 6004586.81845905 | 2101649.91280729 | 37.7509899147675 | -122.426982435992 | (37.7509899147675, -122.426982435992) | 2 | 4 | 5 | 28862 | 22 | ||
18694 | 255585 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 141 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006693 | 2105290 | 37.7611036239675 | -122.419957321446 | (37.7611036239675, -122.419957321446) | 2 | 4 | 7 | 28859 | 19 | ||||
19051 | 224694 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008827.83828 | 2102168.91217 | 37.7526538678042 | -122.412353198162 | (37.7526538678042, -122.412353198162) | 2 | 4 | 7 | 28859 | 19 | |||
19765 | 224602 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3344 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006035.96544 | 2103769.71631 | 37.756892241295 | -122.422121716065 | (37.756892241295, -122.422121716065) | 2 | 4 | 5 | 28859 | 19 | |||
20417 | 224687 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006398.66183 | 2101411.28771 | 37.7504369894718 | -122.420699953558 | (37.7504369894718, -122.420699953558) | 2 | 4 | 5 | 28859 | 19 | |||
20637 | 50305 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.7469054591013 | -122.437986196494 | (37.7469054591013, -122.437986196494) | 2 | 4 | 5 | 63 | 22 | ||
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 | |||
23294 | 224483 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6007282.93524 | 2107366.34912 | 37.7668380128917 | -122.418064187227 | (37.7668380128917, -122.418064187227) | 8 | 4 | 7 | 28853 | 19 | |||
24214 | 64582 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3646 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1988 12:00:00 AM | 18 | 7x12 | Permit Number 25481 | 6005989.81318517 | 2104358.59934784 | 37.758506573723 | -122.422323167129 | (37.758506573723, -122.422323167129) | 2 | 4 | 5 | 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 | |||
25118 | 224700 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | 2 | 4 | 7 | 28859 | 19 | |||
25421 | 226491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008819.81577 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | 2 | 4 | 7 | 28859 | 19 | |||
25611 | 224697 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3186 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007787.21683 | 2102109.23167 | 37.7524315481913 | -122.415947634593 | (37.7524315481913, -122.415947634593) | 2 | 4 | 7 | 28859 | 19 | |||
25933 | 60830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.426449179292 | (37.7520575177016, -122.426449179292) | 2 | 4 | 5 | 28862 | 22 | |
26012 | 642 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3225 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6007512.22413 | 2102054.36572 | 37.7522654344184 | -122.416894720512 | (37.7522654344184, -122.416894720512) | 2 | 4 | 7 | 28859 | 19 | |||
27007 | 224588 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008276.68417 | 2106776.83741 | 37.7652752322039 | -122.414585240843 | (37.7652752322039, -122.414585240843) | 8 | 4 | 7 | 28859 | 19 | |||
27423 | 121150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |||
27637 | 224594 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.22226 | 37.7647909508601 | -122.42263236011 | (37.7647909508601, -122.42263236011) | 8 | 4 | 5 | 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 | |||
28862 | 224598 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3375 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005862.87598 | 2103720.88852 | 37.7567484073338 | -122.422716854995 | (37.7567484073338, -122.422716854995) | 2 | 4 | 5 | 28859 | 19 | |||
28999 | 224659 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009169.14858 | 2102873.09479 | 37.7546065423583 | -122.41122262175 | (37.7546065423583, -122.41122262175) | 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 | |||
32764 | 224689 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006377.96332 | 2101451.22022 | 37.7505454684046 | -122.420774365244 | (37.7505454684046, -122.420774365244) | 2 | 4 | 5 | 28859 | 19 | |||
33181 | 224693 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 281 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006755.71735 | 2102172.37571 | 37.7525468808523 | -122.41951921745 | (37.7525468808523, -122.41951921745) | 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 | |||
35053 | 224682 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.7506386642487 | -122.420640252069 | (37.7506386642487, -122.420640252069) | 2 | 4 | 5 | 28859 | 19 | |||
35509 | 224601 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3328 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006122.42737 | 2103775.96782 | 37.756914282788 | -122.421823142019 | (37.756914282788, -122.421823142019) | 2 | 4 | 5 | 28859 | 19 | |||
36047 | 69485 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33606 | 6008946.01217425 | 2105621.19939594 | 37.7621396967865 | -122.412188502645 | (37.7621396967865, -122.412188502645) | 8 | 4 | 7 | 28859 | 19 | ||
36309 | 577 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3024 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008801.63126 | 2102168.54838 | 37.7526513982496 | -122.412443801263 | (37.7526513982496, -122.412443801263) | 2 | 4 | 7 | 28859 | 19 | |||
36516 | 226493 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008772.32666 | 2104949.65017 | 37.7602860290962 | -122.41274173856 | (37.7602860290962, -122.41274173856) | 2 | 4 | 7 | 28859 | 19 | |||
37042 | 224690 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006361.82473 | 2101451.21677 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | 2 | 4 | 5 | 28859 | 19 | |||
38124 | 552 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2904 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009418.497 | 2102204.07854 | 37.7527835545272 | -122.410313070807 | (37.7527835545272, -122.410313070807) | 2 | 4 | 7 | 28859 | 19 | |||
38685 | 224661 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 602 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008966.38412 | 2105242.83972 | 37.7611019507102 | -122.412091302998 | (37.7611019507102, -122.412091302998) | 2 | 4 | 7 | 28859 | 19 | |||
39537 | 61715 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 281 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21715 | 6004926.94134289 | 2108179.4823523 | 37.7689377963385 | -122.42627108706 | (37.7689377963385, -122.42627108706) | 8 | 4 | 5 | 28853 | 19 | ||
39650 | 224603 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3360 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6005941.90978 | 2103767.20067 | 37.7568800285 | -122.42244681736 | (37.7568800285, -122.42244681736) | 2 | 4 | 5 | 28859 | 19 | |||
39671 | 97123 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3305 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 24053 | 6008171 | 2104436 | 37.7588418942892 | -122.414785099498 | (37.7588418942892, -122.414785099498) | 2 | 4 | 7 | 28859 | 19 | ||
39862 | 7496 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2696 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008261.67558 | 2102751.78327 | 37.754222512966 | -122.414352332587 | (37.754222512966, -122.414352332587) | 2 | 4 | 7 | 28859 | 19 | |||
40421 | 61705 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 57 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21704 | 6005150.34156307 | 2107947.67774505 | 37.7683139415326 | -122.42548186082 | (37.7683139415326, -122.42548186082) | 8 | 4 | 5 | 28853 | 19 | ||
40635 | 24450 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1384 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006415.18821 | 2101529.37673 | 37.7507621663522 | -122.420651186023 | (37.7507621663522, -122.420651186023) | 2 | 4 | 5 | 28859 | 19 | |||
41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
42243 | 226471 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008696.07449 | 2105092.67763 | 37.760674469666 | -122.413015573106 | (37.760674469666, -122.413015573106) | 2 | 4 | 7 | 28859 | 19 | |||
42368 | 255609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 355X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006938 | 2104061 | 37.7577428748963 | -122.419022796788 | (37.7577428748963, -122.419022796788) | 2 | 4 | 7 | 28859 | 19 | ||||
42763 | 224607 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3540 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6005920.82892 | 2102594.51157 | 37.753658906948 | -122.42243640053 | (37.753658906948, -122.42243640053) | 2 | 4 | 5 | 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 | |||
45475 | 224673 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 610 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007868.35883 | 2104304.97763 | 37.7584651276847 | -122.415822498411 | (37.7584651276847, -122.415822498411) | 2 | 4 | 7 | 28859 | 19 | |||
46703 | 633 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3182 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007808.47554 | 2102110.59584 | 37.7524364890666 | -122.415874214834 | (37.7524364890666, -122.415874214834) | 2 | 4 | 7 | 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 | |||
47963 | 226470 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008736.33721 | 2105092.98384 | 37.76067757053 | -122.412876343665 | (37.76067757053, -122.412876343665) | 2 | 4 | 7 | 28859 | 19 | |||
50241 | 61716 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1984 12:00:00 AM | Permit Number 21716 | 6004986.55656035 | 2108182.89626107 | 37.7689505396343 | -122.426065124893 | (37.7689505396343, -122.426065124893) | 8 | 4 | 5 | 28853 | 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 | |||
50861 | 60838 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | 2 | 4 | 5 | 28862 | 22 | ||
50896 | 226475 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3160 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008399.69622 | 2105072.76604 | 37.7606031552393 | -122.414039206643 | (37.7606031552393, -122.414039206643) | 2 | 4 | 7 | 28859 | 19 | |||
51336 | 24449 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006348.43077 | 2102831.95647 | 37.7543349884778 | -122.420974512988 | (37.7543349884778, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
51538 | 66220 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | 8 | 4 | 5 | 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 | |||
52542 | 224684 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006347.14535 | 2101407.65794 | 37.7504241193009 | -122.420877843938 | (37.7504241193009, -122.420877843938) | 2 | 4 | 5 | 28859 | 19 | |||
52676 | 224579 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2577 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008913.82756 | 2103471.3398 | 37.7562348656635 | -122.412147871222 | (37.7562348656635, -122.412147871222) | 2 | 4 | 7 | 28859 | 19 | |||
54116 | 24446 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6006345.52984 | 2102866.64807 | 37.7544300800889 | -122.420987008139 | (37.7544300800889, -122.420987008139) | 2 | 4 | 5 | 28859 | 19 | |||
54673 | 224671 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009345.91132 | 2104426.34813 | 37.758881337533 | -122.410721013192 | (37.758881337533, -122.410721013192) | 2 | 4 | 7 | 28859 | 19 | |||
54721 | 224580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | Permit Number 781047 | 6008616.55983 | 2106802.76672 | 37.7653655169234 | -122.413411521233 | (37.7653655169234, -122.413411521233) | 8 | 4 | 7 | 28859 | 19 | ||
55089 | 600 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3078 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6008460.582 | 2102146.28241 | 37.7525711157729 | -122.413621638824 | (37.7525711157729, -122.413621638824) | 2 | 4 | 7 | 28859 | 19 | |||
55241 | 5358 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004797.67228 | 2107012.30465 | 37.7657256990156 | -122.426635095043 | (37.7657256990156, -122.426635095043) | 8 | 4 | 5 | 28862 | 3 | |||
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 | |||
56192 | 61710 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | 8 | 4 | 5 | 28862 | 19 | ||
56378 | 34142 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.413688890617 | (37.7637880127631, -122.413688890617) | 8 | 4 | 7 | 28859 | 19 | ||
57015 | 224709 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6006609.60192 | 2103216.71936 | 37.7554061772577 | -122.420098619173 | (37.7554061772577, -122.420098619173) | 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 | |||
58923 | 226481 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007993.23947 | 2105048.90017 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
59240 | 60839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.426286473113 | (37.7522506515925, -122.426286473113) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
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 | |||
61066 | 224608 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3552 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005826.64329 | 2102589.60435 | 37.7536401192198 | -122.422761767144 | (37.7536401192198, -122.422761767144) | 2 | 4 | 5 | 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 | |||
62313 | 61708 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 580 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | 8 | 4 | 5 | 28853 | 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 |
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) );