402 rows where Fire Prevention Districts = 2 and qSpecies_id = 97 sorted by qCaretaker_id

View and edit SQL

These facets timed out: Fire Prevention Districts

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)
1108 627 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3166 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3x3   6007870.94281 2102116.96374 37.7524574855488 -122.415658642859 (37.7524574855488, -122.415658642859) 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
3343 23100 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1406 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     27 3X3   6006427.47457 2101357.75439 37.7502916230775 -122.420596517121 (37.7502916230775, -122.420596517121) 2 4 5 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
4358 224705 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3282X 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 Width 3ft   6007157.84145 2102080.74215 37.7523179179397 -122.418122104462 (37.7523179179397, -122.418122104462) 2 4 7 28859 19
5652 657 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3262 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007285.35691 2102087.12511 37.7523426205157 -122.417681586846 (37.7523426205157, -122.417681586846) 2 4 7 28859 19
5744 26220 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 765X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005701.2867 2098677.11468 37.7428902448864 -122.422917229343 (37.7428902448864, -122.422917229343) 2 7 7 28859 2
5761 224699 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3236 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 Width 3ft   6007526.74961 2102095.67359 37.7523796734842 -122.416847415286 (37.7523796734842, -122.416847415286) 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
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
7021 5742 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1755 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005373.18109 2098196.81653 37.741552935912 -122.424017580443 (37.741552935912, -122.424017580443) 2 7 5 28859 7
7593 224702 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3236 24th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 3ft   6007468.55757 2102099.56491 37.7523870848126 -122.417048929078 (37.7523870848126, -122.417048929078) 2 4 7 28859 19
7928 5672 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1422 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6005185.06241 2100046.61651 37.7466214421279 -122.424799598532 (37.7466214421279, -122.424799598532) 2 7 5 63 22
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
76501 5708 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1603 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 3X3   6005329.17263 2098980.11676 37.7437012157418 -122.424225442544 (37.7437012157418, -122.424225442544) 2 7 5 28859 22
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
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
107274 24448 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1156 Valencia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006348.61536 2102840.94797 37.7543596874688 -122.420974512988 (37.7543596874688, -122.420974512988) 2 4 5 28859 19
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
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
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
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
114985 5689 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1535 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6005306.00348 2099419.02782 37.7449050572203 -122.424336766952 (37.7449050572203, -122.424336766952) 2 7 5 28859 22
115391 224618 Planning Code 138.1 required 2 Ficus microcarpa :: Chinese Banyan 97 165 Sussex St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198) 2 7 5 63 7
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
125391 554 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2912X 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009391.31353 2102200.13523 37.7527712032402 -122.410406798162 (37.7527712032402, -122.410406798162) 2 4 7 28859 19
126791 23101 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1406 Valencia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     28 3X3   6006426.26721 2101342.93585 37.7502508667074 -122.420599640465 (37.7502508667074, -122.420599640465) 2 4 5 28859 19
127460 24447 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1156 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6006347.02184 2102851.32539 37.754388091646 -122.420980760555 (37.754388091646, -122.420980760555) 2 4 5 28859 19
127918 611 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3108 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6008224.09237 2102134.47643 37.752525416718 -122.414438627958 (37.752525416718, -122.414438627958) 2 4 7 28859 19
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
135138 574 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3000 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6008882.07656 2102170.50291 37.7526612791072 -122.412165744373 (37.7526612791072, -122.412165744373) 2 4 7 28859 19
136653 5127 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2764 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/18/1994 12:00:00 AM 15 3X3   6002472.72131 2095943.62285 37.7352020045603 -122.433885356532 (37.7352020045603, -122.433885356532) 2 7 5 63 7
136983 626 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3155 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6007952.38293 2102079.53558 37.7523592939498 -122.415374359065 (37.7523592939498, -122.415374359065) 2 4 7 28859 19
144232 5748 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1770 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 5X5   6005291.42369 2098088.82872 37.7412518096224 -122.424292591354 (37.7412518096224, -122.424292591354) 2 7 5 63 7
147724 5576 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1040 Dolores St 3 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6005062.54747 2102282.8606 37.7527547312707 -122.425382354736 (37.7527547312707, -122.425382354736) 2 4 5 28862 22
153957 5685 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1506 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 5x5   6005209.87097 2099535.96992 37.7452207246578 -122.424677493096 (37.7452207246578, -122.424677493096) 2 7 5 63 22
155173 28743 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 750 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6005621.99358 2098694.18206 37.742932633526 -122.42319261615 (37.742932633526, -122.42319261615) 2 7 5 28859 22
158181 612 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3114 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6008205.07322 2102132.16672 37.7525180063146 -122.414504236196 (37.7525180063146, -122.414504236196) 2 4 7 28859 19
168632 590 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3049 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008590.89573 2102118.12773 37.7525011260356 -122.413168999261 (37.7525011260356, -122.413168999261) 2 4 7 28859 19
177687 224701 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3230 24th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     17 Width 3ft   6007503.74003 2102097.04469 37.7523821439458 -122.416927083514 (37.7523821439458, -122.416927083514) 2 4 7 28859 19
178369 556 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2934 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009338.07942 2102203.47128 37.7527773788967 -122.410591127672 (37.7527773788967, -122.410591127672) 2 4 7 28859 19
183317 5133 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2796 Diamond St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002464.77756 2095726.89475 37.7346064681217 -122.433897334607 (37.7346064681217, -122.433897334607) 2 7 5 63 7
186316 224703 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3236 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6007440.93162 2102096.08231 37.7523759682811 -122.417144217627 (37.7523759682811, -122.417144217627) 2 4 7 28859 19
186380 596 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3066 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 3x3   6008530.73419 2102152.94469 37.7525933479176 -122.413379510765 (37.7525933479176, -122.413379510765) 2 4 7 28859 19
189515 23099 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1406 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 5x4   6006424.41645 2101384.80463 37.7503657245067 -122.420609012309 (37.7503657245067, -122.420609012309) 2 4 5 28859 19
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
625 245416 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2761 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010170.0429 2102204.1541 37.7528258621349 -122.407714081565 (37.7528258621349, -122.407714081565) 2 4 7 28859 19
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
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
3917 224706 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3200 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6007512.60917 2102684.32552 37.753995182337 -122.416938018377 (37.753995182337, -122.416938018377) 2 4 7 28859 19
4293 641 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3200 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007604.52296 2102099.47851 37.7523944952114 -122.41657873113 (37.7523944952114, -122.41657873113) 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
5380 640 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3200 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007574.72227 2102100.08892 37.7523944952223 -122.416681830316 (37.7523944952223, -122.416681830316) 2 4 7 28859 19
5854 224657 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 900X Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007803.71411 2097712.06394 37.7403588367925 -122.415579287554 (37.7403588367925, -122.415579287554) 2 7 7 28859 2
6718 226469 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3001 20th St 1 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
8296 94021 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 67 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2010 12:00:00 AM   3x3 Permit Number 53440 6007432 2099002 37.7438798129267 -122.416955902584 (37.7438798129267, -122.416955902584) 2 7 7 28859 2
8711 224685 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3513 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006366.00015 2101408.94489 37.7504287157262 -122.420812733918 (37.7504287157262, -122.420812733918) 2 4 5 28859 19
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
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
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
11588 224634 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 248 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6006846.03495 2097621.06949 37.740055107862 -122.418884118001 (37.740055107862, -122.418884118001) 2 7 7 28859 2
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
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
13648 224656 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 998X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007860.71313 2097707.80133 37.7403503364023 -122.415381905247 (37.7403503364023, -122.415381905247) 2 7 7 28859 2
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
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
16426 224652 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6007400.92537 2098998.39155 37.7438681568958 -122.417063096086 (37.7438681568958, -122.417063096086) 2 7 7 28859 2
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
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
20642 62333 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 54 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/1985 12:00:00 AM     Permit Number 22475 6005123.90294191 2096395.98906268 37.7365941933288 -122.424751419367 (37.7365941933288, -122.424751419367) 2 7 5 28859 2
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
22962 224637 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 343 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006160.37028 2098038.58649 37.741162883772 -122.421284510199 (37.741162883772, -122.421284510199) 2 7 7 28859 2
23053 48044 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3350 Mission St 9 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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);