trees

713 rows where qSpecies_id = 102 sorted by XCoord

✎ 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)
4056 249318 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 198X Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3                      
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
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
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
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
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
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
109399 88090 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1875 38th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   3x3 Permit Number 51093 5984391.2 2102428.5 37.7519650432303 -122.49687727463 (37.7519650432303, -122.49687727463) 1 8 3 56 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
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
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
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
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
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
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
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
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
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
182091 32300 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2367 32nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1996 12:00:00 AM 1   Permit Number 36876 5986385.4755 2099136.6325 37.7430431173924 -122.489738810464 (37.7430431173924, -122.489738810464) 1 8 3 29491 35
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
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
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
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
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
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
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
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
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
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
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
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
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
117294 206752 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 10 Beachmont Dr 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 10ft   5990858.79883 2095874.41908 37.7343460811043 -122.474033463291 (37.7343460811043, -122.474033463291) 1 8 4 64 40
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
24421 206756 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2245 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991004.48671 2100128.5419 37.7460352505192 -122.473840030798 (37.7460352505192, -122.473840030798) 1 8 4 29491 40
37595 206755 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2249 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5991006.69103 2100092.27446 37.7459357971944 -122.473829763244 (37.7459357971944, -122.473829763244) 1 8 4 29491 40
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
51473 206731 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2272 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991055.69121 2099958.73625 37.745571973779 -122.473650589497 (37.745571973779, -122.473650589497) 1 8 4 29491 40
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
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
114238 206716 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1418 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991169.70618 2105739.42575 37.7614508337096 -122.473677961264 (37.7614508337096, -122.473677961264) 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
170589 48015 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2515 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45737 5991376.23311352 2098294.58385123 37.741021197596 -122.472420918053 (37.741021197596, -122.472420918053) 1 8 4 29491 40
95147 50072 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2523 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2003 12:00:00 AM     Permit Number 46803 5991378.06178128 2098242.3918878 37.7408779976528 -122.47241079131 (37.7408779976528, -122.47241079131) 1 8 4 29491 40
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
26030 206732 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2430 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991403.39763 2098862.37414 37.7425817765239 -122.472368375716 (37.7425817765239, -122.472368375716) 1 8 4 29491 40
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
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
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
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
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
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
89824 206754 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1995 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5991572.63095 2101920.9351 37.7509895886981 -122.472006100028 (37.7509895886981, -122.472006100028) 1 8 4 29491 12
16997 38011 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 2537 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM     Permit Number 40222 5991707.38932153 2098162.62971781 37.7406780464622 -122.471266299952 (37.7406780464622, -122.471266299952) 1 8 4 29491 40
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
8537 78846 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 259 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5992056.72748 2086721.95578 37.7092849811889 -122.469225944831 (37.7092849811889, -122.469225944831) 9 8 4 64 24
154602 206735 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 251 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992283.73753 2097815.15281 37.7397572847581 -122.469248240839 (37.7397572847581, -122.469248240839) 1 8 4 59 40
36656 50121 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 251 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46844 5992306.20915001 2097823.24522432 37.7397808029858 -122.469171133031 (37.7397808029858, -122.469171133031) 1 8 4 59 40
107812 206734 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 169 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992377.97144 2098072.2993 37.7404687888048 -122.468941131337 (37.7404687888048, -122.468941131337) 1 8 4 59 40
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
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
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
41560 206719 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 1624 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5992799.45091 2104376.41203 37.757802607033 -122.467942255237 (37.757802607033, -122.467942255237) 1 8 4 56 12
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
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
78986 82093 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 90 Corona St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52272 5992884.13871167 2091762.58426518 37.7231731092186 -122.466732469761 (37.7231731092186, -122.466732469761) 9 8 4 59 40
83092 78499 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 90 Corona St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52272 5992884.13871167 2091762.58426518 37.7231731092186 -122.466732469761 (37.7231731092186, -122.466732469761) 9 8 4 59 40
155288 78634 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 90 Corona St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52272 5992884.13871167 2091762.58426518 37.7231731092186 -122.466732469761 (37.7231731092186, -122.466732469761) 9 8 4 59 40
48847 40753 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 120 Corona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/13/1999 12:00:00 AM     Permit Number 41723 5992987.31701285 2091988.45595539 37.7237992517995 -122.466392213704 (37.7237992517995, -122.466392213704) 9 8 4 59 40
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
43642 255804 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 3 Sidewalk: Curb side : Cutout Tree Private 2       2x3   5993243 2092509 37.7252432887469 -122.465546165723 (37.7252432887469, -122.465546165723) 9 8 4 59 40
125907 255803 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       2x3   5993243 2092509 37.7252432887469 -122.465546165723 (37.7252432887469, -122.465546165723) 9 8 4 59 40
153975 255802 Undocumented 4 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       2x3   5993243 2092509 37.7252432887469 -122.465546165723 (37.7252432887469, -122.465546165723) 9 8 4 59 40
79532 40759 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 125 De Soto St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46577 5993244.02089224 2091981.15429222 37.723794012147 -122.465504308143 (37.723794012147, -122.465504308143) 9 8 4 59 40
104240 38918 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 116 De Soto St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40728 5993276.12701887 2091907.60614304 37.7235939185401 -122.465387983379 (37.7235939185401, -122.465387983379) 9 8 4 59 40
160194 38917 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 116 De Soto St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40728 5993276.12701887 2091907.60614304 37.7235939185401 -122.465387983379 (37.7235939185401, -122.465387983379) 9 8 4 59 40
114294 218319 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 401 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993296 2099913 37.7455758855388 -122.465900686894 (37.7455758855388, -122.465900686894) 1 8 4 29491 40
58539 38948 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1998 12:00:00 AM     Permit Number 40745 5993321.52837855 2092510.8724856 37.7252529591009 -122.465274839058 (37.7252529591009, -122.465274839058) 9 8 4 59 40
62160 38946 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1998 12:00:00 AM     Permit Number 40745 5993321.52837855 2092510.8724856 37.7252529591009 -122.465274839058 (37.7252529591009, -122.465274839058) 9 8 4 59 40
132380 38945 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2002 12:00:00 AM     Permit Number 45897 5993321.52837855 2092510.8724856 37.7252529591009 -122.465274839058 (37.7252529591009, -122.465274839058) 9 8 4 59 40
135540 38947 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 151 Urbano Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1998 12:00:00 AM     Permit Number 40745 5993321.52837855 2092510.8724856 37.7252529591009 -122.465274839058 (37.7252529591009, -122.465274839058) 9 8 4 59 40
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
15986 55366 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 160 San Aleso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/2003 12:00:00 AM     Permit Number 46504 5993337.43694089 2094535.94135118 37.7308142184714 -122.465366881335 (37.7308142184714, -122.465366881335) 9 8 4 59 40
26826 49650 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 160 San Aleso Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2003 12:00:00 AM     Permit Number 46504 5993337.43694089 2094535.94135118 37.7308142184714 -122.465366881335 (37.7308142184714, -122.465366881335) 9 8 4 59 40
81516 216368 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 169 San Aleso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/19/2018 12:00:00 AM 3 3x3 Permit Number 781223 5993370.12553 2094468.19953 37.7306301012917 -122.465248953901 (37.7306301012917, -122.465248953901) 9 8 4 59 40
107244 206733 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 455 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993506.7952 2099451.53822 37.7443209862166 -122.46513828423 (37.7443209862166, -122.46513828423) 1 8 4 29491 40
93536 206739 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 496 Pacheco St 6 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   5993527.20185 2101910.60143 37.7510741249729 -122.465246305396 (37.7510741249729, -122.465246305396) 1 8 4 29491 12
90628 206715 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 201 Moraga St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993624.37216 2103900.25206 37.7565427971383 -122.465054774977 (37.7565427971383, -122.465054774977) 1 8 4 56 12
136374 206758 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 161 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5993644.01897 2093962.07142 37.7292561890115 -122.464265339281 (37.7292561890115, -122.464265339281) 9 8 4 59 40
11985 206738 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2110 09th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5993654.98108 2101316.80215 37.7494510717083 -122.46476131899 (37.7494510717083, -122.46476131899) 1 8 4 29491 40
12296 206714 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 201 Moraga St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993663.54553 2103899.42942 37.7565427971281 -122.464919240823 (37.7565427971281, -122.464919240823) 1 8 4 56 12
122510 95097 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 180 Dorantes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2010 12:00:00 AM     Permit Number 54031 5993663.8 2099799.9 37.7452865520346 -122.464620689927 (37.7452865520346, -122.464620689927) 1 8 4 29491 40
176727 95098 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 180 Dorantes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2010 12:00:00 AM     Permit Number 54031 5993663.8 2099799.9 37.7452865520346 -122.464620689927 (37.7452865520346, -122.464620689927) 1 8 4 29491 40
163032 206737 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2110 09th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993674.35078 2101279.72748 37.7493503908303 -122.46469164671 (37.7493503908303, -122.46469164671) 1 8 4 29491 40

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