trees
443 rows where qSpecies_id = 32 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
73749 | 233470 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008786.34502 | 2104633.52501 | 37.7594188083449 | -122.412670907051 | (37.7594188083449, -122.412670907051) | 2 | 4 | 7 | 28859 | 19 | |||
73865 | 233504 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 303 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004169.36699 | 2109042.82598 | 37.7712654778421 | -122.428953047263 | (37.7712654778421, -122.428953047263) | 7 | 9 | 11 | 29492 | 10 | |||
74150 | 199995 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1094 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6017857.178 | 2092387.3649 | 37.7262982485858 | -122.380448036499 | (37.7262982485858, -122.380448036499) | 10 | 3 | 8 | 58 | 1 | |||
75504 | 233412 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2685 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008988 | 2102801 | 37.7543984253045 | -122.411843990089 | (37.7543984253045, -122.411843990089) | 2 | 4 | 7 | 28859 | 19 | |||
75963 | 194537 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012568.21907 | 2107279.59323 | 37.7668958572755 | -122.399777047179 | (37.7668958572755, -122.399777047179) | 14 | 3 | 8 | 28856 | 20 | |||
78670 | 233379 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 397 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007387.94989 | 2096274.13101 | 37.7363872111847 | -122.41691498673 | (37.7363872111847, -122.41691498673) | 2 | 7 | 7 | 28859 | 2 | |||
78766 | 233383 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008607.04739 | 2107902.88148 | 37.7683856427104 | -122.413522234974 | (37.7683856427104, -122.413522234974) | 8 | 4 | 7 | 28853 | 19 | |||
79575 | 233467 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008792.16391 | 2104566.15897 | 37.7592341631379 | -122.412646020091 | (37.7592341631379, -122.412646020091) | 2 | 4 | 7 | 28859 | 19 | |||
79956 | 233364 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006470.82119 | 2104891.78129 | 37.7599976884594 | -122.420697473213 | (37.7599976884594, -122.420697473213) | 2 | 4 | 7 | 28859 | 19 | |||
80099 | 233453 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2840 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008939.52264 | 2101917.23039 | 37.7519690727134 | -122.411949188506 | (37.7519690727134, -122.411949188506) | 2 | 4 | 7 | 28859 | 19 | |||
81331 | 233407 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009039.77718 | 2101237.37153 | 37.7501079563364 | -122.411554463491 | (37.7501079563364, -122.411554463491) | 2 | 4 | 7 | 28859 | 19 | |||
81445 | 233420 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008882.84351 | 2104050.40662 | 37.75782311337 | -122.412295951823 | (37.75782311337, -122.412295951823) | 2 | 4 | 7 | 28859 | 19 | |||
81814 | 194532 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2200 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010402.10466 | 2107886.85819 | 37.7684422757183 | -122.407312137446 | (37.7684422757183, -122.407312137446) | 8 | 4 | 8 | 28853 | 19 | |||
83677 | 178356 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6009662.10656 | 2090649.30438 | 37.7210702863525 | -122.408655555513 | (37.7210702863525, -122.408655555513) | 9 | 3 | 7 | 309 | 28 | |||
84140 | 233377 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007431.42413 | 2096297.49525 | 37.7364538095851 | -122.416766332396 | (37.7364538095851, -122.416766332396) | 2 | 7 | 7 | 28859 | 2 | |||
84326 | 233436 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 73 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000375.83482 | 2101284.56019 | 37.7497477337837 | -122.441518177039 | (37.7497477337837, -122.441518177039) | 2 | 4 | 5 | 28862 | 22 | |||
85920 | 139838 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 875 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005379.6259 | 2112337.1416 | 37.7803792970953 | -122.425001133553 | (37.7803792970953, -122.425001133553) | 7 | 9 | 11 | 28852 | 41 | |||
86913 | 233475 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008784.35145 | 2104752.62578 | 37.7597457200079 | -122.412686221592 | (37.7597457200079, -122.412686221592) | 2 | 4 | 7 | 28859 | 19 | |||
87307 | 141826 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1020 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004640.8141 | 2112287.0177 | 37.7801999083923 | -122.427553457164 | (37.7801999083923, -122.427553457164) | 7 | 9 | 11 | 29490 | 41 | |||
89268 | 233371 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009946.29944 | 2104530.48554 | 37.7592009197153 | -122.408651928554 | (37.7592009197153, -122.408651928554) | 2 | 4 | 7 | 28859 | 19 | |||
89574 | 194545 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.7676657471131 | -122.400048025518 | (37.7676657471131, -122.400048025518) | 14 | 3 | 8 | 28856 | 20 | |||
92938 | 139937 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800 GOLDEN GATE AVE | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005368.7488 | 2112395.1092 | 37.7805378474705 | -122.425042888178 | (37.7805378474705, -122.425042888178) | 7 | 9 | 11 | 28852 | 41 | |||
93433 | 233446 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 180 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006684.57542 | 2102745.85147 | 37.7541175063307 | -122.419805927624 | (37.7541175063307, -122.419805927624) | 2 | 4 | 7 | 28859 | 19 | |||
93471 | 233385 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008614.2246 | 2107803.41147 | 37.768112924207 | -122.413490373789 | (37.768112924207, -122.413490373789) | 8 | 4 | 7 | 28853 | 19 | |||
93667 | 233434 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 20 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006113.31148 | 2102315.53922 | 37.7529037696113 | -122.421750938181 | (37.7529037696113, -122.421750938181) | 2 | 4 | 5 | 28859 | 19 | |||
95271 | 233433 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2807 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007897.90504 | 2106755.67526 | 37.7651958382412 | -122.415893853325 | (37.7651958382412, -122.415893853325) | 8 | 4 | 7 | 28859 | 19 | |||
96009 | 132214 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2678 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6000146.66842 | 2118183.0353 | 37.7961336156155 | -122.443524371168 | (37.7961336156155, -122.443524371168) | 13 | 9 | 1 | 57 | 17 | |||
97136 | 233479 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2180 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008744.74823 | 2105468.88661 | 37.7617101855999 | -122.41287383096 | (37.7617101855999, -122.41287383096) | 2 | 4 | 7 | 28859 | 19 | |||
98544 | 211316 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 45 Linares Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5993952.85587 | 2102199.15235 | 37.7518909495221 | -122.463795303226 | (37.7518909495221, -122.463795303226) | 1 | 8 | 4 | 29491 | 40 | |||
98646 | 233497 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 60 Yukon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000229.80091 | 2104520.72602 | 37.7586251368655 | -122.442255452052 | (37.7586251368655, -122.442255452052) | 2 | 4 | 5 | 28862 | 3 | |||
99887 | 9457 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | 7 | 9 | 11 | 28852 | 41 | |||
101577 | 233486 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008669.96247 | 2107902.14816 | 37.7683871616767 | -122.413304564874 | (37.7683871616767, -122.413304564874) | 8 | 4 | 7 | 28853 | 19 | |||
101767 | 233405 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | 2 | 4 | 7 | 28859 | 19 | |||
101848 | 132211 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2700 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004866.10803 | 2118906.26122 | 37.7983874290946 | -122.427245699623 | (37.7983874290946, -122.427245699623) | 13 | 9 | 1 | 57 | 17 | |||
102670 | 98213 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
103041 | 249943 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 331 Filbert St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011269.12703 | 2120027.36915 | 37.8018257441226 | -122.405168167193 | (37.8018257441226, -122.405168167193) | 3 | 1 | 10 | 308 | 23 | |||
104215 | 233392 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007791.82881 | 2106445.05823 | 37.7643369919914 | -122.416238745127 | (37.7643369919914, -122.416238745127) | 8 | 4 | 7 | 28859 | 19 | |||
107332 | 233378 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 514 Andover St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007432.33067 | 2096315.60507 | 37.7365035861596 | -122.416764480695 | (37.7365035861596, -122.416764480695) | 2 | 7 | 7 | 28859 | 2 | |||
107980 | 233484 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1818 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008611.01854 | 2107834.46107 | 37.7681979991668 | -122.413503659485 | (37.7681979991668, -122.413503659485) | 8 | 4 | 7 | 28853 | 19 | |||
110100 | 12389 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 1450 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6004617.47643 | 2113882.98777 | 37.7845807261574 | -122.427747939391 | (37.7845807261574, -122.427747939391) | 13 | 9 | 11 | 28858 | 41 | |||
113488 | 233386 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008614.93876 | 2107785.11216 | 37.7680627186577 | -122.413486609222 | (37.7680627186577, -122.413486609222) | 8 | 4 | 7 | 28853 | 19 | |||
113569 | 9450 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 6 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.7806176146029 | -122.424439561439 | (37.7806176146029, -122.424439561439) | 7 | 9 | 11 | 28852 | 41 | |||
113956 | 233451 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008950.63348 | 2101756.58641 | 37.751528603671 | -122.411899414636 | (37.751528603671, -122.411899414636) | 2 | 4 | 7 | 28859 | 19 | |||
114649 | 194547 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.7378863594562 | -122.381824001685 | (37.7378863594562, -122.381824001685) | 10 | 3 | 8 | 58 | 1 | |||
115599 | 96503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6008639.8 | 2104954 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | 2 | 4 | 7 | 28859 | 19 | |||
117702 | 233490 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 918 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001888.71802 | 2101354.60643 | 37.7500261396126 | -122.436291586193 | (37.7500261396126, -122.436291586193) | 2 | 4 | 5 | 28862 | 22 | |||
118450 | 199989 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1054 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018046.698 | 2092242.698 | 37.7259114771391 | -122.379782821602 | (37.7259114771391, -122.379782821602) | 10 | 3 | 8 | 58 | 1 | |||
118535 | 194531 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2221 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011908.13677 | 2101346.92633 | 37.75056924647 | -122.401643151235 | (37.75056924647, -122.401643151235) | 10 | 3 | 8 | 28856 | 1 | |||
119013 | 233396 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007784.70136 | 2106598.65312 | 37.7647583270588 | -122.416274276453 | (37.7647583270588, -122.416274276453) | 8 | 4 | 7 | 28859 | 19 | |||
119104 | 194546 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 184 Hooper St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6012481.42509 | 2107546.77644 | 37.7676246435913 | -122.40009602143 | (37.7676246435913, -122.40009602143) | 14 | 3 | 8 | 28856 | 20 | |||
119309 | 233476 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.53012 | 2104788.45028 | 37.7598440959392 | -122.412688136268 | (37.7598440959392, -122.412688136268) | 2 | 4 | 7 | 28859 | 19 | |||
119326 | 233469 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008788.18662 | 2104615.29768 | 37.7593688636119 | -122.412663249315 | (37.7593688636119, -122.412663249315) | 2 | 4 | 7 | 28859 | 19 | |||
120408 | 178359 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003629.76511 | 2092456.58351 | 37.7256929707372 | -122.429636417784 | (37.7256929707372, -122.429636417784) | 9 | 7 | 6 | 28861 | 5 | |||
121600 | 194541 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012465.16673 | 2107386.76068 | 37.7671843696864 | -122.40014101809 | (37.7671843696864, -122.40014101809) | 14 | 3 | 8 | 28856 | 20 | |||
121618 | 233399 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.39498 | 2106706.34258 | 37.7650536626339 | -122.416303716638 | (37.7650536626339, -122.416303716638) | 8 | 4 | 7 | 28859 | 19 | |||
123083 | 233500 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4090 20th St | 10 | : Yard | Tree | Private 2 | 3 | Width 3ft | 6003098.24212 | 2104183.0577 | 37.7578610449587 | -122.432310971886 | (37.7578610449587, -122.432310971886) | 2 | 4 | 5 | 28862 | 3 | |||
123302 | 233425 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2197 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008802.53088 | 2105481.30644 | 37.7617475308496 | -122.412674861355 | (37.7617475308496, -122.412674861355) | 8 | 4 | 7 | 28859 | 19 | |||
123473 | 233367 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1113 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010291.70011 | 2102620.11112 | 37.753974797412 | -122.407322687398 | (37.753974797412, -122.407322687398) | 10 | 4 | 7 | 28859 | 19 | |||
123609 | 139845 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005645.4131 | 2112373.0828 | 37.7804929927223 | -122.424084207294 | (37.7804929927223, -122.424084207294) | 7 | 9 | 11 | 28852 | 41 | |||
123792 | 233403 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3071 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009068.28085 | 2100690.59156 | 37.7486082190041 | -122.411417271913 | (37.7486082190041, -122.411417271913) | 2 | 4 | 7 | 28859 | 19 | |||
123820 | 233428 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2147 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008784.0081 | 2105817.64626 | 37.7626700032421 | -122.412762703536 | (37.7626700032421, -122.412762703536) | 8 | 4 | 7 | 28859 | 19 | |||
125518 | 194542 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4 08th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012450.21381 | 2107404.91238 | 37.7672333764343 | -122.400194013336 | (37.7672333764343, -122.400194013336) | 14 | 3 | 8 | 28856 | 20 | |||
125810 | 194528 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 21 | : Yard | Tree | Private 2 | 3 | 6014977.55524 | 2102273.87418 | 37.7532852503289 | -122.391093555018 | (37.7532852503289, -122.391093555018) | 10 | 3 | 8 | 28856 | 29 | ||||
126321 | 118491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981413.14873 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | 11 | 6 | 2 | 55 | 26 | ||||
126685 | 211312 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2331 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992605.95071 | 2099584.48851 | 37.7446340456409 | -122.468262856351 | (37.7446340456409, -122.468262856351) | 1 | 8 | 4 | 29491 | 40 | |||
127261 | 194536 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 150 Berry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6014975.61342 | 2110964.15152 | 37.7771467490639 | -122.391707837847 | (37.7771467490639, -122.391707837847) | 6 | 2 | 9 | 28856 | 20 | |||
127900 | 233452 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2846 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008941.56896 | 2101881.90811 | 37.7518722004517 | -122.411939616143 | (37.7518722004517, -122.411939616143) | 2 | 4 | 7 | 28859 | 19 | |||
128475 | 233508 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1941 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008712.28974 | 2107211.2482 | 37.7664924870523 | -122.413109298673 | (37.7664924870523, -122.413109298673) | 8 | 4 | 7 | 28853 | 19 | |||
128800 | 233449 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3210 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008043.39989 | 2105643.53791 | 37.7621503452727 | -122.415311884029 | (37.7621503452727, -122.415311884029) | 8 | 4 | 7 | 28859 | 19 | |||
129061 | 233460 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008873.95519 | 2103097.13758 | 37.7552051536125 | -122.41225931703 | (37.7552051536125, -122.41225931703) | 2 | 4 | 7 | 28859 | 19 | |||
129097 | 233493 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001723.63115 | 2103489.69631 | 37.7558792035671 | -122.437015303929 | (37.7558792035671, -122.437015303929) | 2 | 4 | 5 | 28862 | 22 | |||
129117 | 233389 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008670.89575 | 2107897.67859 | 37.7683749416751 | -122.413301020619 | (37.7683749416751, -122.413301020619) | 8 | 4 | 7 | 28853 | 19 | |||
129486 | 233438 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 125 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007605.04677 | 2098050.53292 | 37.7412770284006 | -122.416290169252 | (37.7412770284006, -122.416290169252) | 2 | 7 | 7 | 28859 | 2 | |||
129807 | 233368 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3505 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006128.23738 | 2104906.34475 | 37.7600183620686 | -122.421883341755 | (37.7600183620686, -122.421883341755) | 2 | 4 | 5 | 28859 | 19 | |||
129967 | 98212 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
130406 | 233503 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 354 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004006.37155 | 2109072.69928 | 37.7713382752792 | -122.429518986121 | (37.7713382752792, -122.429518986121) | 7 | 9 | 11 | 29492 | 10 | |||
130437 | 233397 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 271 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007782.29383 | 2106638.7453 | 37.7648682754772 | -122.416285443329 | (37.7648682754772, -122.416285443329) | 8 | 4 | 7 | 28859 | 19 | |||
130450 | 194526 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 15 | : Yard | Tree | Private 2 | 5 | 6014989.61274 | 2102184.78595 | 37.7530413020381 | -122.391045631074 | (37.7530413020381, -122.391045631074) | 10 | 3 | 8 | 28856 | 29 | ||||
131234 | 132216 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2860 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999249.48209 | 2118404.06668 | 37.7966893013211 | -122.446644714701 | (37.7966893013211, -122.446644714701) | 13 | 9 | 1 | 57 | 17 | |||
131550 | 233462 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2598 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008860.64869 | 2103366.96238 | 37.7559452848687 | -122.412324405443 | (37.7559452848687, -122.412324405443) | 2 | 4 | 7 | 28859 | 19 | |||
131782 | 233419 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2525 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008908.13628 | 2103593.41402 | 37.7565697345137 | -122.412176180999 | (37.7565697345137, -122.412176180999) | 2 | 4 | 7 | 28859 | 19 | |||
134754 | 233376 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 476 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003431.53598 | 2100120.0067 | 37.7467237571152 | -122.430868343305 | (37.7467237571152, -122.430868343305) | 2 | 7 | 5 | 63 | 22 | |||
134828 | 233384 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1812 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008606.4822 | 2107885.73241 | 37.7683385236202 | -122.413522976899 | (37.7683385236202, -122.413522976899) | 8 | 4 | 7 | 28853 | 19 | |||
136531 | 178357 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | 9 | 3 | 7 | 309 | 28 | |||
137193 | 233435 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 650 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001680.56547 | 2099436.84867 | 37.7447486021689 | -122.436874115749 | (37.7447486021689, -122.436874115749) | 2 | 7 | 5 | 63 | 22 | |||
137671 | 233408 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2949 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009035.34127 | 2101297.66233 | 37.7502732526072 | -122.411574062399 | (37.7502732526072, -122.411574062399) | 2 | 4 | 7 | 28859 | 19 | |||
138077 | 233414 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2627 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008932.10074 | 2103132.99229 | 37.7553068651207 | -122.412060765599 | (37.7553068651207, -122.412060765599) | 2 | 4 | 7 | 28859 | 19 | |||
138417 | 233502 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 6 Park Hill Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6001148.61748 | 2107774.29044 | 37.7676109487195 | -122.439310982617 | (37.7676109487195, -122.439310982617) | 15 | 5 | 5 | 29492 | 3 | |||
139810 | 233372 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3265 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009039.47947 | 2099686.62589 | 37.7458499362223 | -122.411445948568 | (37.7458499362223, -122.411445948568) | 2 | 7 | 7 | 28859 | 2 | |||
140452 | 233472 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2355 Harrison St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008783.57561 | 2104687.59979 | 37.7595671299267 | -122.412684307851 | (37.7595671299267, -122.412684307851) | 2 | 4 | 7 | 28859 | 19 | |||
140574 | 98214 | Undocumented 4 | Pistacia chinensis :: Chinese Pistache 32 | 2801X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008059.7 | 2106775 | 37.765257994239 | -122.415335609912 | (37.765257994239, -122.415335609912) | 8 | 4 | 7 | 28859 | 19 | |||
144108 | 194527 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1 25th St | 16 | : Yard | Tree | Private 2 | 3 | 6014969.95823 | 2102191.83984 | 37.7530595798584 | -122.391114093749 | (37.7530595798584, -122.391114093749) | 10 | 3 | 8 | 28856 | 29 | ||||
144188 | 233489 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1850 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008682.13256 | 2107685.30091 | 37.7677924328048 | -122.413247133243 | (37.7677924328048, -122.413247133243) | 8 | 4 | 7 | 28853 | 19 | |||
144954 | 233390 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1717 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008668.46209 | 2108152.59543 | 37.7690747473364 | -122.413327467893 | (37.7690747473364, -122.413327467893) | 8 | 4 | 7 | 28853 | 19 | |||
145019 | 233421 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008868.39184 | 2104298.37433 | 37.7585031654107 | -122.412363458525 | (37.7585031654107, -122.412363458525) | 2 | 4 | 7 | 28859 | 19 | |||
148038 | 233491 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 580 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001369.26473 | 2101468.92323 | 37.7503104980297 | -122.438096067791 | (37.7503104980297, -122.438096067791) | 2 | 4 | 5 | 28862 | 22 | |||
148679 | 233387 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1815 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008673.96808 | 2107833.61209 | 37.768199202458 | -122.41328586256 | (37.768199202458, -122.41328586256) | 8 | 4 | 7 | 28853 | 19 | |||
150163 | 233365 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 200 Lexington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006473.17565 | 2104847.55108 | 37.7598763753088 | -122.420686190322 | (37.7598763753088, -122.420686190322) | 2 | 4 | 7 | 28859 | 19 | |||
152223 | 233459 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2652 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008875.1197 | 2103072.85924 | 37.7551385561152 | -122.412253573936 | (37.7551385561152, -122.412253573936) | 2 | 4 | 7 | 28859 | 19 | |||
152413 | 233363 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008602.87705 | 2108217.80859 | 37.7692501250135 | -122.413558936315 | (37.7692501250135, -122.413558936315) | 8 | 4 | 7 | 28853 | 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) );