trees
713 rows where qSpecies_id = 102 sorted by Supervisor 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
6404 | 73766 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3834 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5996504.18251 | 2114976.06965 | 37.7871197485358 | -122.45589607746 | (37.7871197485358, -122.45589607746) | 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 | |||
27356 | 250731 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986887.59373 | 2114422.31311 | 37.785042671624 | -122.489126191619 | (37.785042671624, -122.489126191619) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
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 | |||
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 | |||
45672 | 45575 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44316 | 5997787.21690008 | 2115155.59999905 | 37.7876862452164 | -122.451470035928 | (37.7876862452164, -122.451470035928) | 11 | 6 | 1 | 54 | 31 | |||
46128 | 250798 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 286 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986227.55169 | 2114017.5724 | 37.7838928227399 | -122.491379896287 | (37.7838928227399, -122.491379896287) | 11 | 6 | 1 | 55 | 33 | |||
52403 | 82137 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
100649 | 34277 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 190 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52264 | 5987177.45046872 | 2114685.66544071 | 37.7857826757644 | -122.488142750795 | (37.7857826757644, -122.488142750795) | 11 | 6 | 1 | 55 | 33 | ||
101023 | 52695 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2719@ SCOTT Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2006 12:00:00 AM | 8 | Permit Number 48762 | 6001054.39961 | 2116869.28224 | 37.7925781198358 | -122.440289185102 | (37.7925781198358, -122.440289185102) | 13 | 6 | 1 | 29490 | 27 | ||
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 | |||
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 | |||
121227 | 82183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
122332 | 250812 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Sea View Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986123.54872 | 2114165.24712 | 37.78429221705 | -122.491750577926 | (37.78429221705, -122.491750577926) | 11 | 6 | 1 | 55 | 33 | |||
125211 | 250793 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 291 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5986186.21669 | 2113991.39004 | 37.7838185180519 | -122.491520970243 | (37.7838185180519, -122.491520970243) | 11 | 6 | 1 | 55 | 33 | |||
130562 | 250799 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 287 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986184.86396 | 2114012.63209 | 37.7838767635505 | -122.49152721422 | (37.7838767635505, -122.49152721422) | 11 | 6 | 1 | 55 | 33 | |||
135093 | 250730 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2745 Lake St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986865.50029 | 2114420.34296 | 37.7850359725789 | -122.489202482009 | (37.7850359725789, -122.489202482009) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
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 | |||
138721 | 250797 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 286 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986226.59241 | 2114006.99175 | 37.7838637152673 | -122.491382435973 | (37.7838637152673, -122.491382435973) | 11 | 6 | 1 | 55 | 33 | |||
139716 | 45576 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3570 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | Permit Number 44316 | 5997787.21690008 | 2115155.59999905 | 37.7876862452164 | -122.451470035928 | (37.7876862452164, -122.451470035928) | 11 | 6 | 1 | 54 | 31 | |||
140337 | 82182 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 301-311 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 50624 | 5994571.67850182 | 2114861.96423825 | 37.786695343884 | -122.462573787528 | (37.786695343884, -122.462573787528) | 11 | 6 | 1 | 54 | 11 | ||
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 | |||
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 | |||
162960 | 250813 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Sea View Ter | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5986113.64494 | 2114167.67929 | 37.7842983162539 | -122.491785020157 | (37.7842983162539, -122.491785020157) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
169045 | 250635 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 194 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5987172.85547 | 2114685.13825 | 37.7857809601798 | -122.488158609233 | (37.7857809601798, -122.488158609233) | 11 | 6 | 1 | 55 | 33 | |||
170928 | 250890 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 236 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5986835.39418 | 2114381.01597 | 37.7849262346079 | -122.489303745667 | (37.7849262346079, -122.489303745667) | 11 | 6 | 1 | 55 | 33 | |||
186278 | 34276 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 190 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52264 | 5987177.45046872 | 2114685.66544071 | 37.7857826757644 | -122.488142750795 | (37.7857826757644, -122.488142750795) | 11 | 6 | 1 | 55 | 33 | ||
186431 | 250925 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 275 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5987109.38515 | 2114117.08948 | 37.7842175580435 | -122.488336434905 | (37.7842175580435, -122.488336434905) | 11 | 6 | 1 | 55 | 33 | |||
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 | ||||
77921 | 41778 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770942 | 6006325.04545 | 2118559.33959 | 37.7975172684732 | -122.422172662639 | (37.7975172684732, -122.422172662639) | 13 | 9 | 10 | 28858 | 32 |
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 | |||
11641 | 223098 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004264.58531 | 2109293.13989 | 37.7719581680779 | -122.428641529305 | (37.7719581680779, -122.428641529305) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
23956 | 255489 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 415 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781958 | 6004580.17678 | 2109974.62519 | 37.7738472162761 | -122.427598435585 | (37.7738472162761, -122.427598435585) | 7 | 9 | 11 | 28852 | 10 |
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 | |||
29934 | 49988 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 300@ GOUGH Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2003 12:00:00 AM | 2 | Permit Number 46733 | 6005922.1673 | 2110886.7951 | 37.7764276301155 | -122.423021112586 | (37.7764276301155, -122.423021112586) | 7 | 9 | 11 | 28852 | 10 | ||
34628 | 223262 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003313.48049 | 2109165.67905 | 37.7715543194136 | -122.431922366729 | (37.7715543194136, -122.431922366729) | 15 | 9 | 11 | 29492 | 10 | |||
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 | |||
50049 | 223259 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003359.42366 | 2109144.63219 | 37.7714991343099 | -122.43176194386 | (37.7714991343099, -122.43176194386) | 15 | 9 | 11 | 29492 | 10 | |||
55577 | 47062 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |||
75618 | 47063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45049 | 6004269.57542485 | 2109262.75093616 | 37.7718750098204 | -122.42862210153 | (37.7718750098204, -122.42862210153) | 7 | 9 | 11 | 28852 | 10 | |||
98367 | 223261 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003316.11431 | 2109147.66446 | 37.7715050050806 | -122.431911969663 | (37.7715050050806, -122.431911969663) | 15 | 9 | 11 | 29492 | 10 | |||
102601 | 40616 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 298X Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 41623 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
105472 | 41834 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1370 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42219 | 5991486.44352722 | 2106096.79372587 | 37.7624504100425 | -122.472608564807 | (37.7624504100425, -122.472608564807) | 1 | 8 | 11 | 56 | 12 | ||
108678 | 244958 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 270 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005192.4053 | 2109747.089 | 37.7732570676035 | -122.425464439836 | (37.7732570676035, -122.425464439836) | 7 | 9 | 11 | 28852 | 10 | |||
113277 | 42782 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42750 | 6005188.63098476 | 2109645.76261136 | 37.7729786366348 | -122.425470283277 | (37.7729786366348, -122.425470283277) | 7 | 9 | 11 | 28852 | 10 | |||
114791 | 223104 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 83 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998437.43293 | 2105357.67145 | 37.760820864008 | -122.448514522136 | (37.760820864008, -122.448514522136) | 15 | 5 | 11 | 29492 | 12 | |||
120424 | 47060 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 114 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) | 7 | 9 | 11 | 28852 | 10 | |||
128834 | 223258 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003383.91707 | 2109145.40948 | 37.7715026569435 | -122.431677275407 | (37.7715026569435, -122.431677275407) | 15 | 9 | 11 | 29492 | 10 | |||
131760 | 54775 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | Permit Number 10624 | 5994314.61016028 | 2105461.58404027 | 37.7608695883517 | -122.462780967251 | (37.7608695883517, -122.462780967251) | 1 | 5 | 11 | 56 | 12 | |||
132658 | 40613 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 298X Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41623 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | ||||
153519 | 223260 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 280 Laussat St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003343.49773 | 2109142.82285 | 37.7714932635271 | -122.431816903254 | (37.7714932635271, -122.431816903254) | 15 | 9 | 11 | 29492 | 10 | |||
156951 | 223156 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 266 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996995.23335 | 2106707.65337 | 37.7644450050552 | -122.453599902314 | (37.7644450050552, -122.453599902314) | 15 | 5 | 11 | 29492 | 12 | |||
162872 | 254858 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 309 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6000181 | 2110050 | 37.7738043631957 | -122.442821270125 | (37.7738043631957, -122.442821270125) | 15 | 5 | 11 | 29492 | 16 | |
172267 | 244962 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 202 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005157.1549 | 2109800.5724 | 37.7734019283256 | -122.425590183018 | (37.7734019283256, -122.425590183018) | 7 | 9 | 11 | 28852 | 10 | |||
172833 | 46179 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 264 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44506 | 5996989.54812887 | 2106711.44465885 | 37.7644550890537 | -122.453619839598 | (37.7644550890537, -122.453619839598) | 15 | 5 | 11 | 29492 | 12 | ||
176535 | 223097 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 124 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004260.2997 | 2109306.43724 | 37.7719944368218 | -122.428657301609 | (37.7719944368218, -122.428657301609) | 7 | 9 | 11 | 28852 | 10 | |||
180147 | 40615 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 214 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2000 12:00:00 AM | Permit Number 42266 | 6003315.66503025 | 2109129.75149177 | 37.7714557949952 | -122.43191224446 | (37.7714557949952, -122.43191224446) | 15 | 9 | 11 | 29492 | 10 | |||
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 | |||
1861 | 65043 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 744 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 26096 | 5982313.7707 | 2110666.72217 | 37.7744628966917 | -122.504671542451 | (37.7744628966917, -122.504671542451) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
14186 | 261520 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 750 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2020 12:24:00 PM | 5982933.06329 | 2110647.13754 | 37.7744455330351 | -122.502527876502 | (37.7744455330351, -122.502527876502) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
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 | ||
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 | ||
32480 | 51271 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 762 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 3 | Permit Number 47646 | 5991020.68747 | 2110207.63616 | 37.7737107039086 | -122.474519447105 | (37.7737107039086, -122.474519447105) | 11 | 6 | 2 | 54 | 26 | |
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 | |||
48740 | 52468 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 708@ CABRILLO 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 5 | Permit Number 48579 | 5993204.94393 | 2110626.22169 | 37.7749863407078 | -122.466994264438 | (37.7749863407078, -122.466994264438) | 11 | 6 | 2 | 54 | 11 | |
49153 | 68557 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 790 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 4 | Permit Number 32447 | 5982323.24987 | 2110389.74086 | 37.7737029443529 | -122.504618226518 | (37.7737029443529, -122.504618226518) | 11 | 6 | 2 | 55 | 26 | |
49859 | 39855 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 450 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 5 | Permit Number 41162 | 5992829.73528 | 2112398.7593 | 37.7798315856925 | -122.468421167303 | (37.7798315856925, -122.468421167303) | 11 | 6 | 2 | 54 | 11 | |
58450 | 50203 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 678@ BALBOA 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 5 | Permit Number 46911 | 5987873.849 | 2111346.40336 | 37.7766546102325 | -122.485488299813 | (37.7766546102325, -122.485488299813) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
82375 | 41930 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 556 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42289 | 5994717.64459 | 2111772.42244 | 37.7782206983537 | -122.461844674778 | (37.7782206983537, -122.461844674778) | 11 | 6 | 2 | 54 | 11 | |
88157 | 47828 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 847 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | Permit Number 45590 | 5981670.01964511 | 2109974.46011085 | 37.7725242583391 | -122.506847003033 | (37.7725242583391, -122.506847003033) | 11 | 6 | 2 | 55 | 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 | |||
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 | |||
122815 | 41958 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3520 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42314 | 5992457.73238 | 2110034.76352 | 37.773319199455 | -122.469535942454 | (37.773319199455, -122.469535942454) | 11 | 6 | 2 | 54 | 11 | |
127824 | 254345 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 207 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991459 | 2114021 | 37.7842065412002 | -122.473281447405 | (37.7842065412002, -122.473281447405) | 11 | 6 | 2 | 54 | 26 | ||||
127994 | 95817 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 275 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767555 | 5993331.8 | 2113672 | 37.7833565457315 | -122.466776900247 | (37.7833565457315, -122.466776900247) | 11 | 6 | 2 | 54 | 11 | |
130370 | 37597 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 734 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40024 | 5992595.59117005 | 2110448.7797774 | 37.7744639430104 | -122.469089211438 | (37.7744639430104, -122.469089211438) | 11 | 6 | 2 | 54 | 11 | ||
146083 | 46649 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 126 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 2 | Permit Number 44781 | 5990552.50864 | 2114536.58834 | 37.7855696722643 | -122.476455229383 | (37.7855696722643, -122.476455229383) | 11 | 6 | 2 | 54 | 26 | |
153415 | 41932 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 568 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42291 | 5994718.86088 | 2111682.35233 | 37.7779734598848 | -122.461833934507 | (37.7779734598848, -122.461833934507) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
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 | ||||
189418 | 50207 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 742@ BALBOA 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 4 | Permit Number 46915 | 5987580.84632 | 2110887.41206 | 37.775377273985 | -122.486468161484 | (37.775377273985, -122.486468161484) | 11 | 6 | 2 | 55 | 26 | |
3123 | 261802 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2319 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986356 | 2099450 | 37.7439018196285 | -122.489863769411 | (37.7439018196285, -122.489863769411) | 1 | 8 | 3 | 29491 | 35 | ||
4450 | 95446 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.492093817749 | (37.7458386996409, -122.492093817749) | 1 | 8 | 3 | 29491 | 35 |
4932 | 37209 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1915 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39775 | 5986283.2112 | 2102182.1445 | 37.7513993005965 | -122.490316396609 | (37.7513993005965, -122.490316396609) | 1 | 8 | 3 | 29491 | 35 | |
8633 | 264870 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1674 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985361 | 2103822 | 37.755847989753 | -122.493626286002 | (37.755847989753, -122.493626286002) | 1 | 8 | 3 | 56 | 35 |
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) );