trees
713 rows where qSpecies_id = 102 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
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 | ||
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 | ||
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 | ||
13635 | 261439 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 374x Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007239 | 2095686 | 37.7347639531109 | -122.417388303298 | (37.7347639531109, -122.417388303298) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
16611 | 258381 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
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 | ||
17766 | 94165 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53528 | 5993721 | 2103904 | 37.7565586593184 | -122.46472087623 | (37.7565586593184, -122.46472087623) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
19006 | 259153 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 207 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007591 | 2097689 | 37.7402835491894 | -122.416313137546 | (37.7402835491894, -122.416313137546) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
20685 | 103447 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 24 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||
27906 | 103441 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 18 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | |||
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 | ||
30784 | 84349 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 333 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50602 | 6006744.47832295 | 2104177.6342219 | 37.758052226043 | -122.419700351439 | (37.758052226043, -122.419700351439) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
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 | ||
36056 | 83944 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2619 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52652 | 6010400.97039498 | 2103382.22541329 | 37.7560735087835 | -122.406998516177 | (37.7560735087835, -122.406998516177) | 10 | 4 | 7 | 28859 | 19 | ||
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 | ||
40193 | 40224 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 178 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51169 | 6001542.41126351 | 2095210.63653579 | 37.7331365563636 | -122.4370493102 | (37.7331365563636, -122.4370493102) | 9 | 7 | 5 | 63 | 40 | ||
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 | |||
41923 | 49925 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 554 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 3x3 | Permit Number 46683 | 6007843.47911818 | 2104700.44166779 | 37.7595495823703 | -122.415936548093 | (37.7595495823703, -122.415936548093) | 2 | 4 | 7 | 28859 | 19 | |
42671 | 58692 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 323 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2009 12:00:00 AM | 3x3 | Permit Number 767328 | 6003795.85086408 | 2099507.29514061 | 37.7450620283206 | -122.429564888975 | (37.7450620283206, -122.429564888975) | 2 | 7 | 5 | 63 | 22 | |
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
50889 | 84110 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 430 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50443 | 6001483.83359221 | 2103251.57157938 | 37.7552117376117 | -122.437827545895 | (37.7552117376117, -122.437827545895) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | ||
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 | ||
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 | ||
55677 | 103442 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
56531 | 95541 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 325 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767328 | 6003789 | 2099510 | 37.7450690673326 | -122.429588770915 | (37.7450690673326, -122.429588770915) | 2 | 7 | 5 | 63 | 22 | |
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 | ||
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 | ||
63062 | 95640 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 252 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
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 | ||
67391 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
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 | |||
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 | ||
73475 | 103443 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50X Bluxome St | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x2 | 6013250.8 | 2110869.1 | 37.7767898637251 | -122.397667885183 | (37.7767898637251, -122.397667885183) | 6 | 2 | 9 | 28856 | 34 | ||||
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 | ||
78525 | 48933 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2731 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46121 | 6008963.71479016 | 2102556.80594456 | 37.7537265609137 | -122.411910719884 | (37.7537265609137, -122.411910719884) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );