trees

713 rows where qSpecies_id = 102 sorted by TreeID

✎ View and edit SQL

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)
124696 101000 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 500X Ogden Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF       Permit Number 44123 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
81028 103428 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 5 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
92337 103429 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 6 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
159372 103433 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 10 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
122814 103435 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 12 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
111529 103439 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 16 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
165939 103440 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 17 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
27906 103441 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 18 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
55677 103442 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 19 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
73475 103443 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 20 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
160032 103444 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 21 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
20685 103447 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 24 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
83968 103448 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 50X Bluxome St 25 Sidewalk: Property side : Cutout Tree Private 2       2x2   6013250.8 2110869.1 37.7767898637251 -122.397667885183 (37.7767898637251, -122.397667885183) 6 2 9 28856 34
148959 108780 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6006878.58529 2087505.45215 37.7122816418905 -122.418054633195 (37.7122816418905, -122.418054633195) 9 7 8 309 39
185247 108782 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005606.4158 2088034.4515 37.713662477117 -122.422489201534 (37.713662477117, -122.422489201534) 9 7 8 309 18
67548 108784 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005634.22998 2088024.32377 37.7136362375916 -122.422392346349 (37.7136362375916, -122.422392346349) 9 7 8 309 18
22064 113315 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2493x 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984243.3692 2098259.1068 37.7405083669922 -122.497080760951 (37.7405083669922, -122.497080760951) 1 8 3 29491 35
193348 113316 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2495x 39th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984244.2356 2098243.5123 37.7404655994923 -122.497076614535 (37.7404655994923, -122.497076614535) 1 8 3 29491 35
119225 113317 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2497x 39th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   5984244.6688 2098225.7519 37.7404168596308 -122.497073806106 (37.7404168596308, -122.497073806106) 1 8 3 29491 35
44862 114642 Private 9 Crataegus phaenopyrum :: Washington Hawthorn 102 30 MacEdonia St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163197 -122.407019863158 (37.745978163197, -122.407019863158) 2 7 7 28859 2
171134 114965 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 778 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM     Permit Number 776138 5994932 2093225 37.7273065236963 -122.45975933934 (37.7273065236963, -122.45975933934) 9 7 4 28861 40
19525 118867 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 686 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   01/16/2020 12:00:00 AM 3 Width 3ft   5981365.93161 2111081.95893 37.7755472130957 -122.507981064387 (37.7755472130957, -122.507981064387) 11 6 2 55 26
141257 120050 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 178 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5987440.2158 2114793.01422 37.7860927508149 -122.487241556125 (37.7860927508149, -122.487241556125) 11 6 1 55 33
18239 120242 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 288 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988397.89946 2114035.20565 37.7840678224086 -122.483872680677 (37.7840678224086, -122.483872680677) 11 6 2 55 26
44807 121103 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1374 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   5991487.33915366 2106070.76020768 37.7623789807661 -122.472603569045 (37.7623789807661, -122.472603569045) 1 8 11 56 12
43339 123459 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 473 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5995269.10945 2112350.33897 37.7798392345462 -122.459978845187 (37.7798392345462, -122.459978845187) 11 6 2 54 11
69078 124052 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 734 11th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992593.72624 2110428.27416 37.7744075323551 -122.469094169847 (37.7744075323551, -122.469094169847) 11 6 2 54 11
181713 124088 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 601 Funston Ave 3 Sidewalk: Property side : Yard Tree Private 2     3     5991897.07787 2111001.16091 37.7759402465292 -122.471545739628 (37.7759402465292, -122.471545739628) 11 6 2 54 11
104221 126385 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996948.55349 2114990.80972 37.7871857146985 -122.454359725115 (37.7871857146985, -122.454359725115) 11 6 1 54 31
86849 126386 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996909.91849 2114986.59165 37.7871719172822 -122.454493088279 (37.7871719172822, -122.454493088279) 11 6 1 54 31
31442 126387 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5996876.15534 2114980.73672 37.7871539047628 -122.454609477651 (37.7871539047628, -122.454609477651) 11 6 1 54 31
138100 126388 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996839.89046 2114975.9108 37.7871385740184 -122.454734596729 (37.7871385740184, -122.454734596729) 11 6 1 54 31
57338 126389 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996804.8865 2114971.05892 37.7871232441919 -122.454855351396 (37.7871232441919, -122.454855351396) 11 6 1 54 31
29874 126390 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3751 Sacramento St 11 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996763.42592 2114965.78353 37.7871063810023 -122.454998413757 (37.7871063810023, -122.454998413757) 11 6 1 54 31
22791 126391 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3570 Clay St 1 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   5997748.40757 2115473.64195 37.7885572815394 -122.451627258297 (37.7885572815394, -122.451627258297) 11 6 1 54 31
120140 126392 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3570 Clay St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 3ft   5997736.75757 2115472.45394 37.7885533524009 -122.451667479589 (37.7885533524009, -122.451667479589) 11 6 1 54 31
28427 126393 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 405 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5998114.64668 2115082.3398 37.7875038363742 -122.450331914389 (37.7875038363742, -122.450331914389) 11 6 1 54 31
52635 126394 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3024 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6000096.0111 2116132.78718 37.7905012848537 -122.443552302292 (37.7905012848537, -122.443552302292) 13 6 1 29490 27
163636 126395 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 3024 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000079.15965 2116130.17302 37.7904931459848 -122.443610419206 (37.7904931459848, -122.443610419206) 13 6 1 29490 27
54697 126396 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2667 Vallejo St 8 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6000871.5003 2117543.41786 37.7944187047121 -122.440970405375 (37.7944187047121, -122.440970405375) 13 9 1 57 27
137834 126397 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2606 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6001539.80082 2116984.18232 37.7929212300824 -122.438617920106 (37.7929212300824, -122.438617920106) 13 6 1 29490 27
73142 126398 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2606 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6001524.87053 2116983.87261 37.79291953036 -122.438669557357 (37.79291953036, -122.438669557357) 13 6 1 29490 27
160235 126399 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2417 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6001345.88444 2117956.79701 37.7955807430055 -122.439358627814 (37.7955807430055, -122.439358627814) 13 9 1 57 27
77268 126400 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2400 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6005452.647 2118246.02495 37.7966077409047 -122.425169089485 (37.7966077409047, -122.425169089485) 13 9 1 57 17
69555 126401 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 95 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     10     6008076.48902 2119089.50826 37.7990716117224 -122.416149753634 (37.7990716117224, -122.416149753634) 5 1 10 308 32
121602 12681 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1301 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 3X3   5991402.68343 2114747.84559 37.7861989963881 -122.473529316812 (37.7861989963881, -122.473529316812) 11 6 2 54 26
116717 12682 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1301 Lake St 3 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3   5991420.04587 2114750.06606 37.7862060986351 -122.473469409938 (37.7862060986351, -122.473469409938) 11 6 2 54 26
75585 139657 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1696 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6001500.8315 2111848.0092 37.7788163989483 -122.438384612501 (37.7788163989483, -122.438384612501) 15 5 11 29490 41
11345 140075 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 544 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005143.7718 2111312.9909 37.7775539050019 -122.425744146907 (37.7775539050019, -122.425744146907) 7 9 11 28852 10
12597 144628 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 5x5   5988384.27006 2114435.54017 37.7851662339868 -122.4839491984 (37.7851662339868, -122.4839491984) 11 6 2 55 26
179147 145306 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 512 10th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 3ft   5992847.35421 2111936.76759 37.7785640995019 -122.468326596707 (37.7785640995019, -122.468326596707) 11 6 2 54 11
18412 147497 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2019 12:00:00 AM 3 Width 4ft   5989658.48818 2112247.31744 37.7792320844204 -122.479380704451 (37.7792320844204, -122.479380704451) 11 6 2 55 26
11774 158438 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 55 Van Buren St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6002040.0229 2096307.75742 37.7361772698529 -122.43540738986 (37.7361772698529, -122.43540738986) 2 7 5 63 7
2625 161272 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 562 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 03:33:00 PM 3 Width 0ft   6002894.24566 2090355.62698 37.719882537321 -122.432029089275 (37.719882537321, -122.432029089275) 9 7 6 28861 5
182078 161275 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 574 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 12:26:00 PM 3 Width 0ft   6002859.41772 2090297.55139 37.7197211000357 -122.432145332055 (37.7197211000357, -122.432145332055) 9 7 6 28861 5
151742 161277 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 582 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 12:23:00 PM 3 Width 0ft   6002834.75222 2090259.20529 37.7196144116499 -122.432227854755 (37.7196144116499, -122.432227854755) 9 7 6 28861 5
100236 166794 Planning Code 138.1 required 2 Crataegus phaenopyrum :: Washington Hawthorn 102 477 Elizabeth St 1 Sidewalk: Property side : Cutout Tree Private 2   05/30/2019 12:00:00 AM 3 3x3 Permit Number 774858 6003342.48296 2102120.18359 37.7522107277484 -122.431319034046 (37.7522107277484, -122.431319034046) 2 4 5 28862 22
4149 169685 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2585 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6002269.97794 2096798.3861 37.7375374800648 -122.43464741415 (37.7375374800648, -122.43464741415) 2 7 5 63 7
5030 171365 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 12 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2019 12:00:00 AM 3 Width 3ft   6002871.58236 2093130.52409 37.7275005001327 -122.432305504906 (37.7275005001327, -122.432305504906) 9 7 6 28861 5
182808 173672 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
92116 173673 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
67391 173674 Significant Tree 6 Crataegus phaenopyrum :: Washington Hawthorn 102 299x Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014575 2115523 37.789642061391 -122.393412811769 (37.789642061391, -122.393412811769) 6 2 9 28855 6
68909 176076 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 154 Gillette Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012994.7964 2086626.41439 37.7102103233239 -122.396853446553 (37.7102103233239, -122.396853446553) 10 3 8 309 1
186381 176077 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012696.95044 2087397.86987 37.7123120047722 -122.397936950623 (37.7123120047722, -122.397936950623) 10 3 8 309 1
43021 176078 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 230 Tocoloma Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012689.21584 2087374.22772 37.7122466573345 -122.397962026443 (37.7122466573345, -122.397962026443) 10 3 8 309 1
166053 176079 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1183 Munich St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6001144.67239 2087111.03395 37.7108742640178 -122.437844474361 (37.7108742640178, -122.437844474361) 9 7 6 28861 5
8484 180531 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 401 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 4 Width 2ft   6002788.2945 2090951.75373 37.721513361625 -122.432437880612 (37.721513361625, -122.432437880612) 9 7 6 28861 5
6222 180532 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 401 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 15 Width 4ft   6002770.13876 2090966.12434 37.7215517905727 -122.432501665928 (37.7215517905727, -122.432501665928) 9 7 6 28861 5
4597 190929 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 6 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015301.73602 2102030.54675 37.752635108841 -122.389955465678 (37.752635108841, -122.389955465678) 10 3 8 28856 1
108831 190930 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 5 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015277.62058 2102029.1535 37.7526299458258 -122.390038764478 (37.7526299458258, -122.390038764478) 10 3 8 28856 1
180455 190931 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 9ft   6015254.41614 2102028.26395 37.752626216333 -122.390118948029 (37.752626216333, -122.390118948029) 10 3 8 28856 1
114299 190932 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 9ft   6015229.59957 2102026.97334 37.7526212961411 -122.390204678629 (37.7526212961411, -122.390204678629) 10 3 8 28856 1
166719 190933 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015201.2247 2102025.49065 37.7526156511008 -122.390302701123 (37.7526156511008, -122.390302701123) 10 3 8 28856 1
415 190934 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1101 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 9ft   6015168.60212 2102024.17667 37.7526102335912 -122.390415424833 (37.7526102335912, -122.390415424833) 10 3 8 28856 1
65127 190935 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 767 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6011029.84564 2104766.51746 37.7599096376513 -122.404921103652 (37.7599096376513, -122.404921103652) 10 3 8 28856 29
24718 190936 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 1 : Tree Private 2     2 Width 3ft   6012268.87212 2103730.35281 37.7571337389375 -122.400563099634 (37.7571337389375, -122.400563099634) 10 3 8 28856 29
79480 190937 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 2 : Tree Private 2     1 Width 3ft   6012285.9595 2103731.71906 37.7571384433095 -122.400504100505 (37.7571384433095, -122.400504100505) 10 3 8 28856 29
123570 190938 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 22nd St 3 : Tree Private 2     1 Width 3ft   6012303.18984 2103733.08208 37.7571431467556 -122.400444606729 (37.7571431467556, -122.400444606729) 10 3 8 28856 29
74485 190939 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1751 Newhall St 3 : Tree Private 2     5 Width 3ft   6013890.69246 2094981.96022 37.733202810741 -122.394341665249 (37.733202810741, -122.394341665249) 10 3 8 58 1
107999 190940 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1721 Newhall St 2 : Tree Private 2     5 Width 3ft   6013954.61402 2095064.64022 37.7334333861362 -122.394126455691 (37.7334333861362, -122.394126455691) 10 3 8 58 1
39104 190941 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 1 : Tree Private 2     4 Width 3ft   6013964.79274 2095080.10635 37.7334764187035 -122.394092347086 (37.7334764187035, -122.394092347086) 10 3 8 58 1
170665 190942 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 2 : Tree Private 2     3 Width 3ft   6013977.60623 2095098.09187 37.7335265154282 -122.39404930553 (37.7335265154282, -122.39404930553) 10 3 8 58 1
188607 190943 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 3 : Tree Private 2     2 Width 3ft   6013990.64503 2095115.60513 37.7335753279298 -122.3940054519 (37.7335753279298, -122.3940054519) 10 3 8 58 1
14040 190944 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1701 Newhall St 4 : Tree Private 2     5 Width 3ft   6014004.94796 2095137.53702 37.7336363433234 -122.393957536921 (37.7336363433234, -122.393957536921) 10 3 8 58 1
29107 190945 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6013445.03636 2110888.0497 37.7768527094247 -122.396997287698 (37.7768527094247, -122.396997287698) 6 2 9 28856 34
20547 190947 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 7 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   6013395.86609 2110840.5938 37.7767196691005 -122.397164055286 (37.7767196691005, -122.397164055286) 6 2 9 28856 34
28151 190948 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 40 Bluxome St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6013368.27074 2110817.70841 37.7766552947402 -122.397257911242 (37.7766552947402, -122.397257911242) 6 2 9 28856 34
104356 199804 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1315 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015572.2876 2090853.6469 37.7219606159851 -122.388239865807 (37.7219606159851, -122.388239865807) 10 3 8 58 1
143673 199806 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1305 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015615.5318 2090822.5842 37.7218777199193 -122.388088213537 (37.7218777199193, -122.388088213537) 10 3 8 58 1
39701 206703 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1917 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   5990930.40398 2102318.91188 37.75204514457 -122.474255998729 (37.75204514457, -122.474255998729) 1 8 4 29491 12
193388 206704 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1945 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 1ft   5990936.99476 2102144.66077 37.7515670784743 -122.474220493479 (37.7515670784743, -122.474220493479) 1 8 4 29491 12
60460 206705 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1479 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5991135.43811 2105372.76647 37.7604421001312 -122.473769729905 (37.7604421001312, -122.473769729905) 1 8 4 56 12
35038 206706 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1479 16th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5991135.60294 2105348.51695 37.7603755269382 -122.473767390769 (37.7603755269382, -122.473767390769) 1 8 4 56 12
54230 206707 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1601 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   5991123.15013 2104471.83436 37.7579676676953 -122.473746503093 (37.7579676676953, -122.473746503093) 1 8 4 56 12
28323 206708 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1926 16th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5991286.95111 2102293.22218 37.7519952564944 -122.473021145018 (37.7519952564944, -122.473021145018) 1 8 4 29491 12
186629 206709 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1374 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991483.07743 2106081.42222 37.7624080091318 -122.472619086012 (37.7624080091318, -122.472619086012) 1 8 11 56 12
23893 206710 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1370 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5991484.15293 2106105.9073 37.7624753009047 -122.472617151554 (37.7624753009047, -122.472617151554) 1 8 11 56 12
25089 206711 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1366 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5991481.24454 2106127.13421 37.7625334160042 -122.472628758222 (37.7625334160042, -122.472628758222) 1 8 11 56 12
12195 206712 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1831 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993729.968 2103029.70657 37.7541585918487 -122.464626378423 (37.7541585918487, -122.464626378423) 1 8 4 56 12
36830 206713 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1835 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993730.54086 2103003.335 37.7540862153215 -122.464622482542 (37.7540862153215, -122.464622482542) 1 8 4 56 12

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