trees
11,635 rows where qSpecies_id = 27 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
525 | 33087 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
1191 | 34003 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37940 | |||||||||||||||
1227 | 46197 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
2988 | 35689 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
3253 | 33090 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
3443 | 33088 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
3932 | 36559 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
4666 | 36564 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
5488 | 46196 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
6511 | 46719 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
7549 | 34002 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37940 | |||||||||||||||
7997 | 46198 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
8327 | 33086 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
8443 | 36563 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
8960 | 39903 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 41185 | ||||||||||||||
10942 | 36562 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
11566 | 46721 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
11814 | 39901 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 41185 | ||||||||||||||
11949 | 34004 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 37940 | |||||||||||||||
12503 | 33089 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
12540 | 33092 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
12780 | 33093 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
13042 | 39902 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 41185 | ||||||||||||||
14606 | 36560 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
15431 | 36565 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1998 12:00:00 AM | Permit Number 39428 | ||||||||||||||
16113 | 33085 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
17106 | 33091 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
17326 | 33082 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37336 | ||||||||||||||
17709 | 46720 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
19426 | 35691 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38993 | ||||||||||||||
20917 | 34856 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
51332 | 34857 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
60219 | 34860 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
61847 | 34859 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
70302 | 34858 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
110862 | 34855 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
139358 | 34861 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38478 | 6007910.36416897 | 2111288.85125958 | 37.7776435713687 | -122.416171839707 | (37.7776435713687, -122.416171839707) | 7 | 2 | 9 | 28852 | 36 | |||||
16855 | 178604 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988124.07873 | 2089803.353 | 37.7175176953569 | -122.4830433365 | (37.7175176953569, -122.4830433365) | 1 | 8 | 4 | 64 | 14 | ||||
114440 | 178607 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.475437730361 | (37.7180635775375, -122.475437730361) | 1 | 8 | 4 | 64 | 14 | ||||
141024 | 178605 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5988508.84436 | 2089780.72483 | 37.7174779462404 | -122.481711737333 | (37.7174779462404, -122.481711737333) | 1 | 8 | 4 | 64 | 14 | ||||
191962 | 178606 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5989765.07873 | 2089203.5232 | 37.7159660653632 | -122.477327400255 | (37.7159660653632, -122.477327400255) | 1 | 8 | 4 | 64 | 14 | ||||
2264 | 195906 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017536.51639 | 2095200.72855 | 37.7340054943619 | -122.381752144972 | (37.7340054943619, -122.381752144972) | 10 | 3 | 8 | 58 | 1 | |||
17716 | 195902 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017277.44673 | 2095425.6538 | 37.7346087856482 | -122.382663483745 | (37.7346087856482, -122.382663483745) | 10 | 3 | 8 | 58 | 1 | |||
20490 | 195912 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017403.30116 | 2095383.73362 | 37.7345006331863 | -122.382225442864 | (37.7345006331863, -122.382225442864) | 10 | 3 | 8 | 58 | 1 | |||
21631 | 195910 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6017434.18901 | 2095336.95373 | 37.734373890838 | -122.382115399105 | (37.734373890838, -122.382115399105) | 10 | 3 | 8 | 58 | 1 | |||
24763 | 195908 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017495.96555 | 2095243.39437 | 37.7341204070247 | -122.381895309837 | (37.7341204070247, -122.381895309837) | 10 | 3 | 8 | 58 | 1 | |||
39388 | 195917 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017301.45491 | 2095451.6349 | 37.7346814508947 | -122.382582285768 | (37.7346814508947, -122.382582285768) | 10 | 3 | 8 | 58 | 1 | |||
40420 | 195916 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017317.30726 | 2095456.23934 | 37.734694969487 | -122.382527798526 | (37.734694969487, -122.382527798526) | 10 | 3 | 8 | 58 | 1 | |||
40979 | 195913 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017397.96951 | 2095379.84046 | 37.7344896488605 | -122.382243605578 | (37.7344896488605, -122.382243605578) | 10 | 3 | 8 | 58 | 1 | |||
44495 | 195909 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017488.13797 | 2095238.32055 | 37.7341060430571 | -122.38192201971 | (37.7341060430571, -122.38192201971) | 10 | 3 | 8 | 58 | 1 | |||
70220 | 195918 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017279.62246 | 2095456.99753 | 37.7346949695032 | -122.382658141758 | (37.7346949695032, -122.382658141758) | 10 | 3 | 8 | 58 | 1 | |||
77652 | 195911 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017428.56702 | 2095333.9897 | 37.7343654417004 | -122.382134630227 | (37.7343654417004, -122.382134630227) | 10 | 3 | 8 | 58 | 1 | |||
86139 | 195907 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017530.87663 | 2095227.61395 | 37.7340790049315 | -122.381773512858 | (37.7340790049315, -122.381773512858) | 10 | 3 | 8 | 58 | 1 | |||
130916 | 195904 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017314.87785 | 2095412.28408 | 37.7345741428666 | -122.382533140509 | (37.7345741428666, -122.382533140509) | 10 | 3 | 8 | 58 | 1 | |||
132558 | 195903 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017292.8048 | 2095421.03653 | 37.7345969559879 | -122.38261006402 | (37.7345969559879, -122.38261006402) | 10 | 3 | 8 | 58 | 1 | |||
142350 | 195905 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017408.62379 | 2095295.00222 | 37.7342572883311 | -122.382200869793 | (37.7342572883311, -122.382200869793) | 10 | 3 | 8 | 58 | 1 | |||
154392 | 195901 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017261.3966 | 2095426.59216 | 37.7346104754941 | -122.382719040276 | (37.7346104754941, -122.382719040276) | 10 | 3 | 8 | 58 | 1 | |||
186644 | 195914 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017370.42366 | 2095423.78328 | 37.7346087856535 | -122.382341897873 | (37.7346087856535, -122.382341897873) | 10 | 3 | 8 | 58 | 1 | |||
189924 | 195915 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Ardath Ct | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017365.99395 | 2095418.64114 | 37.7345944216785 | -122.382356855387 | (37.7345944216785, -122.382356855387) | 10 | 3 | 8 | 58 | 1 | |||
32923 | 235587 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007111.06981 | 2107271.06482 | 37.7665667099198 | -122.41865188518 | (37.7665667099198, -122.41865188518) | 8 | 4 | 7 | 28853 | 19 | |||
171652 | 134383 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Cedar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007352.83372 | 2114556.88578 | 37.7865854379092 | -122.418332302121 | (37.7865854379092, -122.418332302121) | 13 | 9 | 9 | 28858 | 36 | |||
26353 | 12949 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Lindsay Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016403.18992 | 2095651.77267 | 37.7351813255446 | -122.385701866655 | (37.7351813255446, -122.385701866655) | 10 | 3 | 8 | 58 | 1 | |||
17610 | 105076 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 MATEO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6003644.6 | 2096720.9 | 37.7374026627639 | -122.429889171598 | (37.7374026627639, -122.429889171598) | 2 | 7 | 5 | 63 | 7 | |||
2955 | 13425 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.52143 | 37.7942082021958 | -122.394990759026 | (37.7942082021958, -122.394990759026) | 12 | 2 | 9 | 28855 | 6 | ||
13225 | 13427 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6014172.84776 | 2117212.91542 | 37.7942598232708 | -122.394922634488 | (37.7942598232708, -122.394922634488) | 12 | 2 | 9 | 28855 | 6 | |||
29193 | 13426 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2003 12:00:00 AM | 8 | 4x4 | 6014161.01916 | 2117188.17749 | 37.7941912409866 | -122.394961829643 | (37.7941912409866, -122.394961829643) | 12 | 2 | 9 | 28855 | 6 | ||
60823 | 13430 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4x4 | 6014204.72202 | 2117228.65304 | 37.7943048073789 | -122.394813447799 | (37.7943048073789, -122.394813447799) | 12 | 2 | 9 | 28855 | 6 | |||
68686 | 13428 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2003 12:00:00 AM | 6 | 4x4 | 6014180.24954 | 2117205.51401 | 37.7942399123011 | -122.394896504683 | (37.7942399123011, -122.394896504683) | 12 | 2 | 9 | 28855 | 6 | ||
91640 | 13420 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1991 12:00:00 AM | 30 | 4x4 | 6014066.39965 | 2117110.59561 | 37.7939729575322 | -122.395283788713 | (37.7939729575322, -122.395283788713) | 12 | 2 | 9 | 28855 | 6 | ||
101042 | 13424 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2003 12:00:00 AM | 20 | 4x4 | 6014140.16579 | 2117170.60528 | 37.7941418322359 | -122.395032753763 | (37.7941418322359, -122.395032753763) | 12 | 2 | 9 | 28855 | 6 | ||
110833 | 13423 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2002 12:00:00 AM | 20 | 4x4 | 6014116.98151 | 2117144.48589 | 37.7940688252683 | -122.395111144077 | (37.7940688252683, -122.395111144077) | 12 | 2 | 9 | 28855 | 6 | ||
118223 | 13429 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6014197.04513 | 2117235.79144 | 37.7943239809064 | -122.394840511095 | (37.7943239809064, -122.394840511095) | 12 | 2 | 9 | 28855 | 6 | |||
121357 | 13419 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/1991 12:00:00 AM | 20 | 4x4 | 6014048.53109 | 2117080.60856 | 37.7938896263516 | -122.395343514492 | (37.7938896263516, -122.395343514492) | 12 | 2 | 9 | 28855 | 6 | ||
139303 | 13422 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 4x4 | 6014092.01898 | 2117123.77404 | 37.7940105671925 | -122.39519606617 | (37.7940105671925, -122.39519606617) | 12 | 2 | 9 | 28855 | 6 | ||
157457 | 27316 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6014028.45913 | 2117061.6774 | 37.7938365294714 | -122.395411639052 | (37.7938365294714, -122.395411639052) | 12 | 2 | 9 | 28855 | 6 | |||
163365 | 13418 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6014042.20206 | 2117087.71971 | 37.7939087999011 | -122.395365912104 | (37.7939087999011, -122.395365912104) | 12 | 2 | 9 | 28855 | 6 | |||
184834 | 13421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 30 | 4x4 | 6014072.44813 | 2117102.953 | 37.7939523091002 | -122.395262324595 | (37.7939523091002, -122.395262324595) | 12 | 2 | 9 | 28855 | 6 | ||
163228 | 238635 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Mateo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6003627.19927 | 2096721.571 | 37.7374035197462 | -122.429949381872 | (37.7374035197462, -122.429949381872) | 2 | 7 | 5 | 63 | 7 | |||
4781 | 254118 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
48804 | 254117 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
74634 | 254115 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
75135 | 254116 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
118980 | 254114 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/02/2018 12:00:00 AM | 3 | Permit Number 781123 | 6018720.08887 | 2097065.44422 | 37.739190920851 | -122.377789500691 | (37.739190920851, -122.377789500691) | 10 | 3 | 8 | 58 | 1 | ||
149606 | 133452 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998879.78479 | 2116645.46463 | 37.791839523718 | -122.447797276823 | (37.791839523718, -122.447797276823) | 11 | 6 | 1 | 54 | 30 | |||
165388 | 133453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998880.22963 | 2116633.28355 | 37.7918061031258 | -122.44779486036 | (37.7918061031258, -122.44779486036) | 11 | 6 | 1 | 54 | 30 | |||
23434 | 238646 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003249.79131 | 2096430.02106 | 37.736581609537 | -122.431233451874 | (37.736581609537, -122.431233451874) | 2 | 7 | 5 | 63 | 7 | |||
13379 | 250006 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Starr King Way | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6005940.10765 | 2113829.6095 | 37.784508891608 | -122.423168280499 | (37.784508891608, -122.423168280499) | 13 | 9 | 11 | 28858 | 41 | |||
152858 | 250007 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1 Starr King Way | 2 | : | Tree | Private 2 | 18 | Width 3ft | 6005970.87651 | 2113821.19628 | 37.7844875273108 | -122.423061232398 | (37.7844875273108, -122.423061232398) | 7 | 9 | 11 | 28858 | 41 | |||
50565 | 234648 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003406.84007 | 2105674.08338 | 37.7619725376186 | -122.431350145198 | (37.7619725376186, -122.431350145198) | 15 | 4 | 5 | 28862 | 3 | |||
21633 | 195643 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6015861.55733 | 2112297.6774 | 37.7808574525459 | -122.388736165764 | (37.7808574525459, -122.388736165764) | 6 | 2 | 9 | 28856 | 20 | |||
33454 | 195635 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015919.25107 | 2112489.08509 | 37.7813862125543 | -122.388549937747 | (37.7813862125543, -122.388549937747) | 6 | 2 | 9 | 28856 | 20 | |||
71324 | 195637 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015914.47489 | 2112443.66834 | 37.7812612436563 | -122.388563289988 | (37.7812612436563, -122.388563289988) | 6 | 2 | 9 | 28856 | 20 | |||
82135 | 195646 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015816.94411 | 2112231.01553 | 37.7806719412978 | -122.388885850717 | (37.7806719412978, -122.388885850717) | 6 | 2 | 9 | 28856 | 20 | |||
82187 | 195632 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6015928.19981 | 2112561.72047 | 37.7815861489313 | -122.388524050751 | (37.7815861489313, -122.388524050751) | 6 | 2 | 9 | 28856 | 20 | |||
83406 | 195641 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6015884.8235 | 2112343.32817 | 37.7809840887822 | -122.388658863641 | (37.7809840887822, -122.388658863641) | 6 | 2 | 9 | 28856 | 20 | |||
106567 | 195633 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015927.61372 | 2112541.10483 | 37.7815295105284 | -122.388524638927 | (37.7815295105284, -122.388524638927) | 6 | 2 | 9 | 28856 | 20 | |||
114995 | 195645 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6015833.63304 | 2112252.72759 | 37.7807324827572 | -122.388829631401 | (37.7807324827572, -122.388829631401) | 6 | 2 | 9 | 28856 | 20 | |||
116603 | 195642 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6015873.18226 | 2112320.09829 | 37.7809196595661 | -122.388697514702 | (37.7809196595661, -122.388697514702) | 6 | 2 | 9 | 28856 | 20 | |||
126382 | 195644 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6015847.2765 | 2112274.50081 | 37.7807930233285 | -122.388783952118 | (37.7807930233285, -122.388783952118) | 6 | 2 | 9 | 28856 | 20 | |||
135495 | 195639 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 10 King St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6015901.23898 | 2112391.74663 | 37.7811179447654 | -122.388605454684 | (37.7811179447654, -122.388605454684) | 6 | 2 | 9 | 28856 | 20 |
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) );