trees
3,267 rows where qSpecies_id = 67 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
137800 | 99927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6008996.47999 | 2092997.06161 | 37.7274794299239 | -122.411122192648 | (37.7274794299239, -122.411122192648) | 9 | 3 | 7 | 309 | 28 | ||||
28909 | 99810 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4201-4203 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001860 | 2102333 | 37.7527109432388 | -122.436460912327 | (37.7527109432388, -122.436460912327) | 2 | 4 | 5 | 28862 | 22 | ||||
30513 | 99783 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4214-4216 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001799 | 2101779 | 37.7511863251897 | -122.436632209418 | (37.7511863251897, -122.436632209418) | 2 | 4 | 5 | 28862 | 22 | ||||
33345 | 99749 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4216 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Looks like it was planted at same time with permit to plant tree no. 1 | 6002493 | 2100648 | 37.7481202809952 | -122.434151441743 | (37.7481202809952, -122.434151441743) | 2 | 4 | 5 | 28862 | 22 | ||
98718 | 99596 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3001@Filbert Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 17057 | 6002820 | 2118927.7 | 37.7983303693218 | -122.434327384023 | (37.7983303693218, -122.434327384023) | 13 | 9 | 1 | 57 | 17 | ||||
115506 | 99545 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1345 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6016251.7 | 2093118.1 | 37.7282159817318 | -122.386049062135 | (37.7282159817318, -122.386049062135) | 10 | 3 | 8 | 58 | 1 | ||||
149708 | 99544 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6016344.2389 | 2093074.9592 | 37.7281026467009 | -122.385726142965 | (37.7281026467009, -122.385726142965) | 10 | 3 | 8 | 58 | 1 | |||
33322 | 99543 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6016380.5949 | 2093124.5356 | 37.7282407853998 | -122.385603911567 | (37.7282407853998, -122.385603911567) | 10 | 3 | 8 | 58 | 1 | |||
44455 | 99400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2201X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014717 | 2092863 | 37.7274304716685 | -122.391336797962 | (37.7274304716685, -122.391336797962) | 10 | 3 | 8 | 58 | 1 | |
121944 | 9884 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1530 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6005423.33111 | 2115078.55002 | 37.7879089952385 | -122.425045046399 | (37.7879089952385, -122.425045046399) | 13 | 9 | 1 | 28858 | 41 | |||
33351 | 9883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1530 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6005400.00219 | 2115093.82301 | 37.787949613228 | -122.425126847427 | (37.787949613228, -122.425126847427) | 13 | 9 | 1 | 28858 | 41 | |||
136401 | 9882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1530 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6005403.02502 | 2115071.76703 | 37.7878892237663 | -122.425114819002 | (37.7878892237663, -122.425114819002) | 13 | 9 | 1 | 28858 | 41 | |||
186971 | 9881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1520 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6005407.78962 | 2115025.03332 | 37.7877611737987 | -122.425095007823 | (37.7877611737987, -122.425095007823) | 13 | 9 | 1 | 28858 | 41 | |||
159647 | 9880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1520 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6005412.72445 | 2114999.44781 | 37.7876912011289 | -122.425076113066 | (37.7876912011289, -122.425076113066) | 13 | 9 | 1 | 28858 | 41 | |||
192463 | 9879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1515 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005356.5169 | 2115030.8291 | 37.7877741910602 | -122.42527281445 | (37.7877741910602, -122.42527281445) | 13 | 9 | 11 | 28858 | 27 | |||
78739 | 9878 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1515 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4X4 | 6005350.7284 | 2115053.9831 | 37.787837439149 | -122.425294489862 | (37.787837439149, -122.425294489862) | 13 | 9 | 11 | 28858 | 27 | |||
123587 | 9877 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1511 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6005349.97627 | 2114990.72408 | 37.7876637031607 | -122.425292588834 | (37.7876637031607, -122.425292588834) | 13 | 9 | 11 | 28858 | 27 | |||
189948 | 9876 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1505 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6005371.567 | 2114888.4319 | 37.7873840540746 | -122.425210607423 | (37.7873840540746, -122.425210607423) | 13 | 9 | 11 | 28858 | 27 | |||
114976 | 9875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1505 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6005369.2516 | 2114917.3744 | 37.7874633921653 | -122.425220678493 | (37.7874633921653, -122.425220678493) | 13 | 9 | 11 | 28858 | 27 | |||
118718 | 9874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1505 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4x4 | 6005366.9362 | 2114940.5284 | 37.7875268364754 | -122.42523033753 | (37.7875268364754, -122.42523033753) | 13 | 9 | 11 | 28858 | 27 | |||
67757 | 98119 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060@Greenwich Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 23584 | 6001464 | 2118900 | 37.7981772521061 | -122.439017558255 | (37.7981772521061, -122.439017558255) | 13 | 9 | 1 | 57 | 17 | ||||
183848 | 98118 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060@Greenwich Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 23584 | 6001464 | 2118900 | 37.7981772521061 | -122.439017558255 | (37.7981772521061, -122.439017558255) | 13 | 9 | 1 | 57 | 17 | ||||
60932 | 98117 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001455.49775 | 2118981.69776 | 37.798401088908 | -122.439052836736 | (37.798401088908, -122.439052836736) | 13 | 9 | 1 | 57 | 17 | |||
55296 | 98116 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001457.2753 | 2118966.43976 | 37.7983592955935 | -122.439045591788 | (37.7983592955935, -122.439045591788) | 13 | 9 | 1 | 57 | 17 | |||
147750 | 97909 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
117013 | 97908 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | Permit Number 33440 | 6002143 | 2119896 | 37.8009506172383 | -122.436739355692 | (37.8009506172383, -122.436739355692) | 13 | 9 | 1 | 57 | 17 | |||
9270 | 97907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33440 | 6002166.03814 | 2119855.12291 | 37.8008396887472 | -122.436656706436 | (37.8008396887472, -122.436656706436) | 13 | 9 | 1 | 57 | 17 | ||
75882 | 97766 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400X Amazon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6001498.93462 | 2088909.86278 | 37.7158335880342 | -122.436748746672 | (37.7158335880342, -122.436748746672) | 9 | 7 | 6 | 28861 | 5 | |||
132703 | 97764 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6001442.97937 | 2088937.55839 | 37.715906453794 | -122.436944135186 | (37.715906453794, -122.436944135186) | 9 | 7 | 6 | 28861 | 5 | |||
50289 | 97454 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.8059106699013 | -122.419502281419 | (37.8059106699013, -122.419502281419) | 5 | 1 | 1 | 28858 | 32 | |
100440 | 97343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2211 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002936 | 2114773 | 37.7869292140191 | -122.433628903612 | (37.7869292140191, -122.433628903612) | 13 | 9 | 11 | 29490 | 27 | ||||
161267 | 97342 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002821.40981 | 2114736.53495 | 37.7868225877557 | -122.434022751483 | (37.7868225877557, -122.434022751483) | 13 | 9 | 11 | 29490 | 27 | ||||
108439 | 96863 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 123 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x2 | 5998424 | 2098102 | 37.7408978035844 | -122.448038555069 | (37.7408978035844, -122.448038555069) | 9 | 7 | 4 | 59 | 40 | |||
51011 | 96644 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2215 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767989 | 5988552.97397 | 2114644.11737 | 37.7857487476607 | -122.4833808378 | (37.7857487476607, -122.4833808378) | 11 | 6 | 2 | 55 | 26 | |
45100 | 96476 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5989913.8 | 2103183.8 | 37.7543609517796 | -122.477834745891 | (37.7543609517796, -122.477834745891) | 1 | 8 | 3 | 56 | 35 | |||
79976 | 96339 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1494@ 27th St Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2011 12:00:00 AM | 3x3 | Permit Number 767722 | 6005839 | 2100241 | 37.7471920883951 | -122.422552158036 | (37.7471920883951, -122.422552158036) | 2 | 7 | 5 | 28859 | 22 | ||
142390 | 96210 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201X Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | |
131682 | 95673 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3508 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5 | 5998079 | 2115190 | 37.7877974026763 | -122.450463008357 | (37.7877974026763, -122.450463008357) | 11 | 6 | 1 | 54 | 31 | ||||
86730 | 94495 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5997569.2 | 2107955.8 | 37.7679049841939 | -122.451704762646 | (37.7679049841939, -122.451704762646) | 15 | 5 | 11 | 29492 | 9 | ||||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
114729 | 94064 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 4 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
192464 | 94063 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
173743 | 94062 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
166934 | 94061 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Craut. | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
147767 | 9373 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 292 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x4 | 6001116.19267 | 2097967.75303 | 37.7406827195388 | -122.438720354687 | (37.7406827195388, -122.438720354687) | 2 | 7 | 5 | 63 | 7 | |||
142050 | 93571 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 920 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001349 | 2088904 | 37.7158089679017 | -122.437266569668 | (37.7158089679017, -122.437266569668) | 9 | 7 | 6 | 28861 | 5 | |||||
136306 | 93570 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 920 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6001322.49897 | 2088870.02328 | 37.7157141688559 | -122.437355737785 | (37.7157141688559, -122.437355737785) | 9 | 7 | 6 | 28861 | 5 | ||||
22346 | 93056 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 2.5x8 | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | 15 | 5 | 11 | 29492 | 12 | |||
170725 | 92940 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 369 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5992076 | 2096773 | 37.7368837904176 | -122.469890645 | (37.7368837904176, -122.469890645) | 1 | 8 | 4 | 59 | 40 | ||||
23306 | 92939 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 363 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5992054.1 | 2096847.4 | 37.7370868080983 | -122.469971777828 | (37.7370868080983, -122.469971777828) | 1 | 8 | 4 | 59 | 40 | ||||
109503 | 92937 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 345 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | 1 | 8 | 4 | 59 | 40 | ||||
72818 | 92935 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 345 West Portal Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992182.7 | 2096880.8 | 37.7371859491769 | -122.469529584198 | (37.7371859491769, -122.469529584198) | 1 | 8 | 4 | 59 | 40 | ||||
68518 | 92933 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 333 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992246.1 | 2096943.8 | 37.7373625952097 | -122.469314967671 | (37.7373625952097, -122.469314967671) | 1 | 8 | 4 | 59 | 40 | ||||
56665 | 92931 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 323 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992282 | 2096978 | 37.7374585742898 | -122.469193334242 | (37.7374585742898, -122.469193334242) | 1 | 8 | 4 | 59 | 40 | ||||
184810 | 92930 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 321 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 5992299.8 | 2096997.6 | 37.7375134194845 | -122.469133217923 | (37.7375134194845, -122.469133217923) | 1 | 8 | 4 | 59 | 40 | |||
96074 | 92920 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 366 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 5991958.2 | 2096928.4 | 37.7373036694984 | -122.470309241356 | (37.7373036694984, -122.470309241356) | 1 | 8 | 4 | 59 | 40 | ||||
118457 | 92918 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992028 | 2097000 | 37.7375043003581 | -122.470073124763 | (37.7375043003581, -122.470073124763) | 1 | 8 | 4 | 59 | 40 | ||||
50216 | 92917 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 346 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992028 | 2097000 | 37.7375043003581 | -122.470073124763 | (37.7375043003581, -122.470073124763) | 1 | 8 | 4 | 59 | 40 | ||||
46569 | 92915 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
27779 | 92558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52904 | 5989977.22773 | 2113271.83238 | 37.7820636253324 | -122.478352998578 | (37.7820636253324, -122.478352998578) | 11 | 6 | 2 | 55 | 26 | |
107749 | 9246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5986886.6516554 | 2112572.1737573 | 37.7799626628655 | -122.488993391881 | (37.7799626628655, -122.488993391881) | 11 | 6 | 2 | 55 | 26 | |||
192336 | 9245 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6500 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5986886.6516554 | 2112572.1737573 | 37.7799626628655 | -122.488993391881 | (37.7799626628655, -122.488993391881) | 11 | 6 | 2 | 55 | 26 | |||
156779 | 92263 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52711 | 5992102.6 | 2098202.2 | 37.7408095493016 | -122.469902704935 | (37.7408095493016, -122.469902704935) | 1 | 8 | 4 | 59 | 40 | ||
44059 | 9219 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.7799940793559 | -122.487366491184 | (37.7799940793559, -122.487366491184) | 11 | 6 | 2 | 55 | 26 | |||
68107 | 9218 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.7800013647147 | -122.487262222118 | (37.7800013647147, -122.487262222118) | 11 | 6 | 2 | 55 | 26 | |||
95011 | 9217 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.7799664118712 | -122.487258965224 | (37.7799664118712, -122.487258965224) | 11 | 6 | 2 | 55 | 26 | |||
183311 | 9216 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987396.5402 | 2112575.6349 | 37.7800019123037 | -122.487229736584 | (37.7800019123037, -122.487229736584) | 11 | 6 | 2 | 55 | 26 | |||
92956 | 9215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.7799823187667 | -122.48718974832 | (37.7799823187667, -122.48718974832) | 11 | 6 | 2 | 55 | 26 | |||
132445 | 9184 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 12 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987942.8619 | 2112587.5406 | 37.7800664442915 | -122.485340662126 | (37.7800664442915, -122.485340662126) | 11 | 6 | 2 | 55 | 26 | |||
155606 | 9183 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 11 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987946.551 | 2112592.9065 | 37.7800813924537 | -122.485328293876 | (37.7800813924537, -122.485328293876) | 11 | 6 | 2 | 55 | 26 | |||
139385 | 9182 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987952.9231 | 2112592.5712 | 37.7800808430308 | -122.485306225563 | (37.7800808430308, -122.485306225563) | 11 | 6 | 2 | 55 | 26 | |||
51262 | 9181 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | 11 | 6 | 2 | 55 | 26 | |||
55999 | 9180 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987967.6795 | 2112585.8637 | 37.7800632857697 | -122.485254684827 | (37.7800632857697, -122.485254684827) | 11 | 6 | 2 | 55 | 26 | |||
49661 | 9179 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987967.3441 | 2112595.2541 | 37.7800890496186 | -122.485256534338 | (37.7800890496186, -122.485256534338) | 11 | 6 | 2 | 55 | 26 | |||
20971 | 9178 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | 11 | 6 | 2 | 55 | 26 | |||
90741 | 9177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987977.7406 | 2112589.2174 | 37.7800730801841 | -122.485220125518 | (37.7800730801841, -122.485220125518) | 11 | 6 | 2 | 55 | 26 | |||
138788 | 9176 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987984.4481 | 2112593.2419 | 37.7800845210592 | -122.485197216909 | (37.7800845210592, -122.485197216909) | 11 | 6 | 2 | 55 | 26 | |||
116442 | 9140 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988567.4931 | 2112610.849 | 37.7801668120621 | -122.48318151551 | (37.7801668120621, -122.48318151551) | 11 | 6 | 2 | 55 | 26 | |||
121954 | 9139 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988574.5359 | 2112606.1537 | 37.7801543299329 | -122.483156807286 | (37.7801543299329, -122.483156807286) | 11 | 6 | 2 | 55 | 26 | |||
177875 | 9138 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988580.2372 | 2112606.1537 | 37.7801546617076 | -122.483137084127 | (37.7801546617076, -122.483137084127) | 11 | 6 | 2 | 55 | 26 | |||
78369 | 9137 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.483121185388 | (37.7801678269123, -122.483121185388) | 11 | 6 | 2 | 55 | 26 | |||
53672 | 9099 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.7802479360974 | -122.481022231507 | (37.7802479360974, -122.481022231507) | 11 | 6 | 2 | 55 | 26 | |||
74687 | 9096 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) | 11 | 6 | 2 | 55 | 26 | |||
28132 | 9095 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989203.3055 | 2112634.6929 | 37.7802692605886 | -122.480983721798 | (37.7802692605886, -122.480983721798) | 11 | 6 | 2 | 55 | 26 | |||
21676 | 9094 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.480981153199 | (37.7802427184836, -122.480981153199) | 11 | 6 | 2 | 55 | 26 | |||
18488 | 9093 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.7802564116082 | -122.48095732695 | (37.7802564116082, -122.48095732695) | 11 | 6 | 2 | 55 | 26 | |||
172470 | 9092 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989215.1343 | 2112630.3915 | 37.7802581377407 | -122.480942485969 | (37.7802581377407, -122.480942485969) | 11 | 6 | 2 | 55 | 26 | |||
52293 | 9091 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989224.2748 | 2112631.4669 | 37.7802616218044 | -122.48091094389 | (37.7802616218044, -122.48091094389) | 11 | 6 | 2 | 55 | 26 | |||
169539 | 90664 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3600X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984368.50089 | 2110421.40599 | 37.773909982922 | -122.497545831628 | (37.773909982922, -122.497545831628) | 11 | 6 | 2 | 55 | 26 | ||
5466 | 90663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | 11 | 6 | 2 | 55 | 26 | ||
151865 | 9055 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
97741 | 9054 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
62767 | 9053 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
154847 | 9052 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
56339 | 9051 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
61968 | 9049 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | 11 | 6 | 2 | 55 | 26 | |||
181495 | 9048 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989831.8464 | 2112654.8557 | 37.7803611386504 | -122.478810807949 | (37.7803611386504, -122.478810807949) | 11 | 6 | 2 | 55 | 26 | |||
26918 | 9019 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | 11 | 6 | 2 | 55 | 26 | ||
26672 | 90184 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1718 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990253.28479 | 2111313.46411 | 37.7767025104427 | -122.477254814454 | (37.7767025104427, -122.477254814454) | 11 | 6 | 2 | 55 | 26 |
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) );