trees
713 rows where qSpecies_id = 102 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1016 | 84387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6012577.97369 | 2099023.613 | 37.7442272813575 | -122.399163722146 | (37.7442272813575, -122.399163722146) | 10 | 3 | 8 | 58 | 1 | |||
1593 | 259756 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1523 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015921.70632 | 2096895.74231 | 37.7385703600528 | -122.387453298811 | (37.7385703600528, -122.387453298811) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |
6349 | 78274 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1715 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013961.91267 | 2093099.05364 | 37.7280366912377 | -122.393963673903 | (37.7280366912377, -122.393963673903) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
9024 | 46096 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | Permit Number 44466 | 5995953.68098218 | 2095998.76752974 | 37.734981320791 | -122.456427900432 | (37.734981320791, -122.456427900432) | 9 | 7 | 4 | 59 | 40 | |||
9083 | 39724 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 295 Valdez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41100 | 5996021.32504537 | 2095122.64012846 | 37.7325795705533 | -122.456130709172 | (37.7325795705533, -122.456130709172) | 9 | 7 | 4 | 59 | 40 | ||
9100 | 84393 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2101 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6012494.05335 | 2099085.01558 | 37.7443912025977 | -122.399458212338 | (37.7443912025977, -122.399458212338) | 10 | 3 | 8 | 58 | 1 | |||
10416 | 42198 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1108 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42472 | 6010019.96061049 | 2108918.62513791 | 37.7712538746338 | -122.408706742901 | (37.7712538746338, -122.408706742901) | 8 | 2 | 9 | 28853 | 34 | ||
11449 | 37884 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
11533 | 259758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1547 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015798.86195 | 2096987.35115 | 37.7388150947049 | -122.387884430038 | (37.7388150947049, -122.387884430038) | 10 | 3 | 8 | 58 | 1 | |||
12117 | 223149 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3925 21st St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002289.78631 | 2103524.74331 | 37.7560075979872 | -122.435059863923 | (37.7560075979872, -122.435059863923) | 2 | 4 | 5 | 28862 | 22 | ||||
12137 | 48604 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 45 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45912 | 5994629.49748523 | 2098086.8895364 | 37.7406386779703 | -122.461157347766 | (37.7406386779703, -122.461157347766) | 1 | 8 | 4 | 59 | 40 | ||
12335 | 32449 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4351 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 4 | Permit Number 36968 | 6000424.87812 | 2105754.35735 | 37.7620235013126 | -122.441669319785 | (37.7620235013126, -122.441669319785) | 15 | 5 | 5 | 28862 | 3 | |
13116 | 49003 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 428 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/2002 12:00:00 AM | 6 | Permit Number 46190 | 6003609.57090194 | 2102180.87163122 | 37.7523924957508 | -122.430399732377 | (37.7523924957508, -122.430399732377) | 2 | 4 | 5 | 28862 | 22 | |
13666 | 46097 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | Permit Number 44466 | 5995953.68098218 | 2095998.76752974 | 37.734981320791 | -122.456427900432 | (37.734981320791, -122.456427900432) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
15984 | 52285 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 49 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48443 | 6005568.13669376 | 2099312.5052799 | 37.7446273691442 | -122.423422786255 | (37.7446273691442, -122.423422786255) | 2 | 7 | 5 | 28859 | 22 | ||
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 | ||
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 | ||
17734 | 47651 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 363 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 4 | Permit Number 45455 | 6012960.30928 | 2105372.99833 | 37.761682620471 | -122.3982870765 | (37.761682620471, -122.3982870765) | 10 | 3 | 8 | 28856 | 29 | |
18133 | 48935 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2743 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46123 | 6008967.24880953 | 2102489.58925571 | 37.7535421972635 | -122.411893748881 | (37.7535421972635, -122.411893748881) | 2 | 4 | 7 | 28859 | 19 | ||
18209 | 78205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014348.06009 | 2094265.06475 | 37.7312597751042 | -122.392710275271 | (37.7312597751042, -122.392710275271) | 10 | 3 | 8 | 58 | 1 | |||
19290 | 36416 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39335 | 5995348.52277962 | 2093755.44427738 | 37.7287869399676 | -122.458357809087 | (37.7287869399676, -122.458357809087) | 9 | 7 | 4 | 28861 | 40 | ||
20837 | 39081 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 816 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1998 12:00:00 AM | Permit Number 40779 | 6009882.35970531 | 2104453.69348919 | 37.758986484759 | -122.408867645938 | (37.758986484759, -122.408867645938) | 2 | 4 | 7 | 28859 | 19 | ||
20965 | 37421 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1215 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39901 | 6003240.50544879 | 2101168.34074207 | 37.7495914114978 | -122.431603738981 | (37.7495914114978, -122.431603738981) | 2 | 4 | 5 | 28862 | 22 | ||
21672 | 36567 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/1998 12:00:00 AM | Permit Number 39429 | 6006271.54294487 | 2096111.84764875 | 37.7358787559596 | -122.420763362902 | (37.7358787559596, -122.420763362902) | 2 | 7 | 7 | 28859 | 2 | ||
23447 | 37412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 920 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39890 | 6001892.73765623 | 2101410.4821696 | 37.7501797894928 | -122.436281684424 | (37.7501797894928, -122.436281684424) | 2 | 4 | 5 | 28862 | 22 | ||
24521 | 34871 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 362 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39900 | 6002791.72644386 | 2101550.82973484 | 37.7506161886226 | -122.433182956314 | (37.7506161886226, -122.433182956314) | 2 | 4 | 5 | 28862 | 22 | ||
24836 | 96563 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 567 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | Permit Number 767781 | 6007698 | 2096716 | 37.7376179219065 | -122.415874290579 | (37.7376179219065, -122.415874290579) | 2 | 7 | 7 | 28859 | 2 | ||||
24895 | 35947 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 354 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39109 | 6007155.94334709 | 2095722.46816688 | 37.734859413246 | -122.417678043362 | (37.734859413246, -122.417678043362) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
26989 | 42903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3267 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42817 | 6007744.73028146 | 2104990.07889872 | 37.7603393072133 | -122.416298586055 | (37.7603393072133, -122.416298586055) | 2 | 4 | 7 | 28859 | 19 | ||
27660 | 36691 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 15 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39490 | 6005970.65710535 | 2105699.54901563 | 37.7621874267643 | -122.42248469974 | (37.7621874267643, -122.42248469974) | 8 | 4 | 5 | 28859 | 19 | ||
27807 | 37883 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
28799 | 31813 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 75 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43298 | 6001169.8510551 | 2107531.3716561 | 37.7669451622371 | -122.439220125413 | (37.7669451622371, -122.439220125413) | 15 | 5 | 5 | 29492 | 3 | ||
28874 | 46095 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 647 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2001 12:00:00 AM | Permit Number 44466 | 5995953.68098218 | 2095998.76752974 | 37.734981320791 | -122.456427900432 | (37.734981320791, -122.456427900432) | 9 | 7 | 4 | 59 | 40 | |||
29257 | 37356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Florentine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39862 | 5999496.07093 | 2087702.97116 | 37.7124057060181 | -122.443584900943 | (37.7124057060181, -122.443584900943) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||
30589 | 46576 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 996 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | 2 | 4 | 5 | 28862 | 22 | ||
31335 | 42183 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 730 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42467 | 6012299.41281254 | 2111097.65921114 | 37.7773644110039 | -122.400975101339 | (37.7773644110039, -122.400975101339) | 14 | 2 | 9 | 28856 | 34 | ||
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 | |
35636 | 46604 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2002 12:00:00 AM | Permit Number 44730 | 5995879.19387821 | 2095995.46855673 | 37.7349679860764 | -122.456685188603 | (37.7349679860764, -122.456685188603) | 9 | 7 | 4 | 59 | 40 | |||
35886 | 42461 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 638 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42603 | 5997203.88330057 | 2095296.86249192 | 37.7331257521174 | -122.45205490562 | (37.7331257521174, -122.45205490562) | 9 | 7 | 4 | 59 | 40 | ||
35923 | 40727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 242 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2002 12:00:00 AM | Permit Number 41706 | 6008971.38235478 | 2097242.21876487 | 37.7391343108464 | -122.411508751405 | (37.7391343108464, -122.411508751405) | 10 | 7 | 7 | 28859 | 2 | ||
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 | ||
36871 | 37013 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2649 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39627 | 6008937.84413531 | 2103040.08708157 | 37.7550520906222 | -122.412034337856 | (37.7550520906222, -122.412034337856) | 2 | 4 | 7 | 28859 | 19 | ||
37015 | 39548 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1945 22nd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40973 | 6012286.64815743 | 2103730.55141744 | 37.7571352756248 | -122.400501636831 | (37.7571352756248, -122.400501636831) | 10 | 3 | 8 | 28856 | 29 | ||
37717 | 35412 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1543 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38867 | 6003346.45221762 | 2099263.3283709 | 37.7443666965298 | -122.431101419272 | (37.7443666965298, -122.431101419272) | 2 | 7 | 5 | 63 | 22 | ||
39237 | 39738 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3892 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41105 | 6003712.19802155 | 2104818.42047752 | 37.759640392907 | -122.430232983891 | (37.759640392907, -122.430232983891) | 2 | 4 | 5 | 28862 | 3 | ||
40399 | 37909 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1550 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40172 | 5995790.86348938 | 2094355.79804067 | 37.7304607763423 | -122.456872021896 | (37.7304607763423, -122.456872021896) | 9 | 7 | 4 | 28861 | 40 | ||
40762 | 33518 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 152 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2011 12:00:00 AM | Permit Number 54708 | 6007356.74297376 | 2098199.21824128 | 37.7416713195812 | -122.417159251481 | (37.7416713195812, -122.417159251481) | 2 | 7 | 7 | 28859 | 2 | |||
43301 | 46603 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | Permit No. 49245 | 5995879.19387821 | 2095995.46855673 | 37.7349679860764 | -122.456685188603 | (37.7349679860764, -122.456685188603) | 9 | 7 | 4 | 59 | 40 | |||
43579 | 49061 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 40 | ||
44445 | 52260 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3709 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2005 12:00:00 AM | Permit Number 48425 | 6005749.88940983 | 2101370.1403687 | 37.7502874215485 | -122.422940534627 | (37.7502874215485, -122.422940534627) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
45344 | 39728 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45396 | 5995248.70809754 | 2095241.13740797 | 37.7328605562257 | -122.458810391172 | (37.7328605562257, -122.458810391172) | 9 | 7 | 4 | 59 | 40 | ||
45644 | 48034 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3919 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2003 12:00:00 AM | Permit Number 45755 | 6002353.43840873 | 2102936.81418675 | 37.754396899431 | -122.434797692252 | (37.754396899431, -122.434797692252) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
48196 | 40649 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41645 | 6004716.48108998 | 2094045.77819858 | 37.7301180210727 | -122.425992800888 | (37.7301180210727, -122.425992800888) | 9 | 7 | 6 | 28861 | 5 | ||
48404 | 39862 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4098 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41166 | 6003227.38247548 | 2101282.82127054 | 37.7499050043111 | -122.431657290961 | (37.7499050043111, -122.431657290961) | 2 | 4 | 5 | 28862 | 22 | ||
48576 | 36991 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2859 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | Permit Number 39611 | 6009115.63786489 | 2103311.05195266 | 37.7558060729063 | -122.411438615769 | (37.7558060729063, -122.411438615769) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |
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 | ||
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 | |
50051 | 32387 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 135 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 7 | Permit Number 36930 | 6005715.56726 | 2096415.13611 | 37.736680166259 | -122.422707139641 | (37.736680166259, -122.422707139641) | 2 | 7 | 7 | 28859 | 2 | |
51909 | 37903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1535 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40170 | 5995777.93060406 | 2094290.75580707 | 37.7302814434236 | -122.456912029856 | (37.7302814434236, -122.456912029856) | 9 | 7 | 4 | 28861 | 40 | ||
52921 | 42462 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 639 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42604 | 5997203.09508156 | 2095244.86846619 | 37.7329829438319 | -122.45205388068 | (37.7329829438319, -122.45205388068) | 9 | 7 | 4 | 59 | 40 | ||
53180 | 37904 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1535 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40170 | 5995777.93060406 | 2094290.75580707 | 37.7302814434236 | -122.456912029856 | (37.7302814434236, -122.456912029856) | 9 | 7 | 4 | 28861 | 40 | ||
53488 | 40648 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 5 | Permit Number 41645 | 6004712.3249 | 2093952.72428 | 37.7298622808141 | -122.426000547798 | (37.7298622808141, -122.426000547798) | 9 | 7 | 6 | 28861 | 5 | |
54040 | 36674 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1688 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1998 12:00:00 AM | Permit Number 39479 | 6006203.35466934 | 2107311.37468916 | 37.7666262444629 | -122.421794380159 | (37.7666262444629, -122.421794380159) | 8 | 4 | 7 | 28853 | 19 | ||
54803 | 37898 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
57377 | 82603 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | Permit Number 52217 | 6006478.75414254 | 2105491.02124356 | 37.7616435085797 | -122.420712577969 | (37.7616435085797, -122.420712577969) | 2 | 4 | 7 | 28859 | 19 | |||
57699 | 44791 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 585 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43885 | 6009841.4903569 | 2105563.40623193 | 37.7620312154749 | -122.409087294566 | (37.7620312154749, -122.409087294566) | 8 | 4 | 8 | 28859 | 19 | ||
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 | |
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 | |||
59107 | 39727 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 370 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1999 12:00:00 AM | Permit Number 41101 | 5995248.70809754 | 2095241.13740797 | 37.7328605562257 | -122.458810391172 | (37.7328605562257, -122.458810391172) | 9 | 7 | 4 | 59 | 40 | |||
59595 | 52259 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 3709 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48425 | 6005749.88940983 | 2101370.1403687 | 37.7502874215485 | -122.422940534627 | (37.7502874215485, -122.422940534627) | 2 | 4 | 5 | 28859 | 19 | ||
60958 | 52170 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1438 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48363 | 6010081.42720851 | 2100867.61644364 | 37.7491510642606 | -122.407926289907 | (37.7491510642606, -122.407926289907) | 2 | 4 | 7 | 28859 | 19 | ||
61986 | 49063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 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 | |||
62889 | 52480 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 229@ CORTLAND Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48590 | 6009030.49361029 | 2097316.56869627 | 37.739341775023 | -122.411309621596 | (37.739341775023, -122.411309621596) | 10 | 7 | 7 | 28859 | 2 | ||
63108 | 36694 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2003 12:00:00 AM | Permit Number 39492 | 6005944.11475049 | 2105750.15633024 | 37.7623248851686 | -122.422580096077 | (37.7623248851686, -122.422580096077) | 8 | 4 | 5 | 28859 | 19 | ||
63171 | 37908 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40171 | 5995826.42405766 | 2094314.00617458 | 37.7303480678725 | -122.456746063345 | (37.7303480678725, -122.456746063345) | 9 | 7 | 4 | 28861 | 40 | ||
63308 | 43555 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 315 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43218 | 6003845.16620682 | 2099510.00544467 | 37.7450722623541 | -122.429394558522 | (37.7450722623541, -122.429394558522) | 2 | 7 | 5 | 63 | 22 | ||
66442 | 39725 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 295 Valdez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41100 | 5996021.32504537 | 2095122.64012846 | 37.7325795705533 | -122.456130709172 | (37.7325795705533, -122.456130709172) | 9 | 7 | 4 | 59 | 40 | ||
66829 | 36553 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 330 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39424 | 6006937.03456509 | 2096264.47332115 | 37.7363353189883 | -122.418473308954 | (37.7363353189883, -122.418473308954) | 2 | 7 | 7 | 28859 | 2 | ||
67369 | 32450 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4351 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36968 | 6000436.7321 | 2105755.18306 | 37.7620264438947 | -122.441628380841 | (37.7620264438947, -122.441628380841) | 15 | 5 | 5 | 28862 | 3 | |
68395 | 39125 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 686 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1998 12:00:00 AM | Permit Number 40806 | 6007284.81986171 | 2103320.44807333 | 37.7557290133775 | -122.417770856659 | (37.7557290133775, -122.417770856659) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||
69861 | 82602 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 105 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | Permit Number 52217 | 6006478.75414254 | 2105491.02124356 | 37.7616435085797 | -122.420712577969 | (37.7616435085797, -122.420712577969) | 2 | 4 | 7 | 28859 | 19 | |||
71186 | 37901 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
72802 | 70492 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 46 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1994 12:00:00 AM | 3 | 6004963.53914 | 2091629.12436 | 37.7234963820321 | -122.424966815785 | (37.7234963820321, -122.424966815785) | 9 | 7 | 6 | 28861 | 5 | ||
75439 | 46574 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 996 Sanchez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44710 | 6003759.39576103 | 2102474.00246404 | 37.7532058498338 | -122.429902520856 | (37.7532058498338, -122.429902520856) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
75792 | 46815 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 192 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44895 | 5994691.45503575 | 2096154.19409478 | 37.7353355395411 | -122.460803091527 | (37.7353355395411, -122.460803091527) | 9 | 8 | 4 | 59 | 40 |
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) );